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

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

vickyd — Thu, 31 Aug 2017 15:53:38 GMT

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?

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

mgmeyer — Thu, 31 Aug 2017 17:18:16 GMT

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

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

riccardomuti — Thu, 31 Aug 2017 18:22:02 GMT

Vote/comment on this idea: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/19727650-pass-filter-in-url-power-bi-report-server

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

Anonymous — Wed, 24 Jan 2018 02:58:24 GMT

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

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

sameers — Sat, 10 Feb 2018 23:19:43 GMT

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

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

devrodriguez — Thu, 22 Feb 2018 17:42:41 GMT

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?

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

devrodriguez — Thu, 22 Feb 2018 17:58:23 GMT

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

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

sameers — Thu, 22 Feb 2018 18:07:32 GMT

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?

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

Anonymous — Tue, 13 Mar 2018 15:30:06 GMT

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

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

Anonymous — Tue, 13 Mar 2018 15:34:09 GMT

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

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

arunkumar112 — Thu, 19 Apr 2018 20:22:09 GMT

How we can pass dax function username() to sql query query to fetch data only for logged in user?

How we can pass dax function username or userprinciple name to sql query to retrive data for power BI report. We don't want to load all data then apply filter. only load data only for logged in user name.

Using procedure

RetriveDataForLoggedInUser(@StartDate,@EndDate, @LoggedInUserName)

Row level securty work when data is loaded completely in power BI.

Please suggest?

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

Anonymous — Tue, 08 May 2018 15:37:37 GMT

Anyone have an update on this? We need to be able to filter data in PBI ReportServer reports. If this is not going to be implemented, it could be the last nail in the coffin for using Power BI in my organization. We need to be able to filter data based on user credentials through parameters.

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

arunkumar112 — Tue, 08 May 2018 15:46:17 GMT

I did not get response on this, may be there is no such feature yet. which is most required. Analysing in entire data is very dificult.

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

Udaya — Wed, 27 Jun 2018 19:29:14 GMT

Any update on the above request?

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

Udaya — Wed, 04 Jul 2018 11:27:29 GMT

Auy update on the below request

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

hamedtabari — Sun, 22 Jul 2018 13:44:23 GMT

http://PowerBIServer/Reports/powerbi/ReportPathAndName?filter=QueryName/Column eq 'USERNAME'

PowerBIServer: BI Server URL

ReportPathAndName: Report path and name eg: Type1/ProjectProgress

QueryName: Query Name

Column: Column using in Query eg: username

USERNAME: User Name or any value you want filter data

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

hamedtabari — Sun, 22 Jul 2018 13:46:51 GMT

http://PowerBIServer/Reports/powerbi/ReportPathAndName?filter=QueryName/Column eq 'USERNAME'

PowerBIServer: BI Server URL

ReportPathAndName: Report path and name eg: Type1/ProjectProgress

QueryName: Query Name

Column: Column using in Query eg: username

USERNAME: User Name or any value you want filter data

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

andymc123 — Fri, 14 Sep 2018 14:31:31 GMT

Not sure I agree with the accepted solution on this one. Maybe it shouldn't have the green check mark on it if the answer is "This functionality is not yet supported"...it should be left "unsolved"

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

Anonymous — Fri, 04 Oct 2019 18:47:42 GMT

https://youtu.be/uHWfzPls50c?t=2859

Video from Microsoft

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

luisrh — Fri, 04 Oct 2019 21:58:23 GMT

This is NOT a power bi report. It's an RDL report which has had that functionality always. This is a badly needed feature in Power BI Report Server . MSFT needs to implement it. PLEASE ask for it.