cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper V
Helper V

Passing parameters to a Power BI report in Power BI Report Server

We currently have dashboards built using SSRS that link to different reports and display data per the parameters passed. 

 

e.g. A user based on their role may have access (controlled using row-level security in SSAS Tabular model) to multiple Accounts. Choosing an Account display a 360 dashboard with all key metrics for that Account. User can then click on individual links to take to say Billing report for that Account or Contract details for that account etc. 

 

We would like to now create some reports using Power BI and link to them via the 360 dashboard. Can we pass a filter to a Power BI Report via the URL so it is filtered by that parameter? 

 

I checked this out -> https://powerbi.microsoft.com/en-us/documentation/powerbi-service-url-filters/

However that didn't seem to work on a Power BI Report server report.  

 

Is there a way to achieve what we want?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Power BI Team
Power BI Team

Re: Passing parameters to a Power BI report in Power BI Report Server

Unfortunately this is currently not supported but it is on our backlog and it something we hope to get to soon.

View solution in original post

20 REPLIES 20
Highlighted
Power BI Team
Power BI Team

Re: Passing parameters to a Power BI report in Power BI Report Server

Unfortunately this is currently not supported but it is on our backlog and it something we hope to get to soon.

View solution in original post

Highlighted
Microsoft
Microsoft

Re: Passing parameters to a Power BI report in Power BI Report Server

Highlighted
Advocate I
Advocate I

Re: Passing parameters to a Power BI report in Power BI Report Server

Here is a solution I just tested:

create a new coloumn AAA for example

AAA = "URL?filter=Table/Column eq " & "'" & ColumnName & "'"

 

URL is the url of the report that you want to open

Table is the Table name of the data you want to filter in teh target report (no space accepted as I remembered but I am sure this can be tricked a little)

Column is the Column name of the data you want to filter in the target report

ColumnName is teh name of teh column from the initial report that you will to provide to filter the value

Highlighted
Frequent Visitor

Re: Passing parameters to a Power BI report in Power BI Report Server

Hi Team,

I need to create a power BI report and provide user to input parameters of there choicoe so that they can search for desired results. Currently I don't think this feature is supported in Power BI. Can you share when can we expect this to be provided? My clients want this feature in high demand.

 

Thanks,

Sam

Highlighted
New Member

Re: Passing parameters to a Power BI report in Power BI Report Server

That functionality it's already implemented?. If not when do you think it's ready or what options you give me to supply the functionality?

Highlighted
New Member

Re: Passing parameters to a Power BI report in Power BI Report Server

Have you found how pass parameters  to a Power BI report in Power BI Report Server?

Highlighted
Frequent Visitor

Re: Passing parameters to a Power BI report in Power BI Report Server

From parameter I mean to say to take input from end user like from textbox, click on a button and the results will be shown to the end user. Are you sure this feature is there in current version of Power BI. If so, can you share links to that tutorial?

Highlighted
Regular Visitor

Re: Passing parameters to a Power BI report in Power BI Report Server

hi

is there any updates about this issue?

i have a report that loads many rows 

i want the users to pick the start date and end date and just then run the query

is it possible already ?

thanx

Highlighted
Regular Visitor

Re: Passing parameters to a Power BI report in Power BI Report Server

hi

is there any updates about this issue?

i have a report that loads many rows 

i want the users to pick the start date and end date and just then run the query

is it possible already ?

thanx

Helpful resources

Announcements
May 2020 Community Highlights

May 2020 Community Highlights

It’s time for another PBI Community recap!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Galleries

Galleries

Looking for inspiration on how to present your data? Need instructional videos? Check out our Galleries!

Top Solution Authors
Top Kudoed Authors