Pass parameters from application to power bi embedded

[jswat21]

Hi All,

I am trying to find out a way to pass parameters to power bi embedded from the web application. Basically, the front-end user will have a page where he will make some selections say client id/member id and some 4-5 more filters and a data filter, once he clicks on load, these selected values should be passed as parameters to power bi embedded and then the relevant report should be displayed on the application screen.

Any help on this would be greatly appreciated. 

Thanks

[Anonymous · Accepted solution]

Hi @jswat21 ,

To pass parameters from an application to Power BI Embedded, you can use the URL query string. You can add parameters to the URL query string and then pass it to the Power BI Embedded report. The report can then extract the parameters from the URL query string and use them to filter the data.

Alternatively, you can also pass in one additional filter value on the embed URL when you render the IFrame .

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[jswat21]

Hi @ibarrau 

Thanks for your reply. I did check the Embedded playground and saw Filters and slicers in action.

But I am not looking for how the filters on the report will work.

What I am looking is before the report is loaded/rendered, the user selections on previous page in the web application should be passed as parameter values to the power bi and then based on these selections, the report should be loaded.

The data being retrieved should be filtered before, the report is loaded.

[hmendezm]

Hi jswat21, I have the same requirement, and I was wondering if you found the solution. I am trying to usea parameter but it does not work.

Best

Hmendezm

[Kowsii]

Hi,

Have you implemented above method now?

[jswat21]

Not able to actually.

[hmendezm]

ohk. I have researched possible solutions without success.

What was your workaround?

Thanks 

[ibarrau]

Hi, you can play around with the Power Bi Embedded playground. That place will let you understand how to solve actions with code for embedding.

https://playground.powerbi.com/en-us/explore-features

On that link go to filters, check the one you want and how it's done.

I hope that helps,