Power View - Add Parameter Support - by Jon Capezzuto

Status : 


Sign in
to vote
ID 777763 Comments
Status Active Workarounds
Type Suggestion Repros 0
Opened 1/29/2013 7:11:46 AM
Access Restriction Public


Provide the ability to pass URL parameters when opening a Power View report to set view filters, similar to passing report filter values to SSRS
Sign in to post a comment.
Posted by Paul Hocker on 3/24/2015 at 1:32 PM
You can do this, refer to this Blog article.


It only seems to work with RDLX files currently. PV reports created from Excel do not accept the parameters from what I can tell.


http://my.sharepointsite.net/sites/sitename/_layouts/15/ReportServer/AdHocReportDesigner.aspx?RelativeReportUrl=/sites/sitename/PowerPivot%20Gallery/reportname.rdlx&ViewMode=Presentation&rf=[TableName].[FieldName] eq 'Value'

RF Syntax:

&rf=[Table Name].[Field Name] eq 'Value'

Posted by Miami BI on 2/20/2015 at 1:08 PM
We are struggling to implement requested reports in PowerView due to this issue. Very difficult when we are trying to roll out new visualization technology only to be handcuffed with certain restrictions that are available in competitors tools.
Posted by Erik Roll on 10/17/2014 at 11:33 AM
Significant functionality to compete with other BI tools like QlikView and Tableau. This is a glaring omission at present.