Handling Access to Embedded Power BI Reports using Query Parameters

[Acen_navadhan]

Hello everyone,

I have successfully embedded a Power BI report in a web application.

Objective:
- I would like to pass query parameters (or similar) to the Power BI embed URL so that the reports are filtered based on specific conditions. This method would allow me to handle access dynamically based on the parameters passed from the web app.

Key Points:
- Controlling access dynamically through query parameters.
- Filtering reports based on user-specific conditions passed from the web app.

Question:
Is it possible to pass query parameters or similar values while embedding a Power BI report to handle access and filtering? If so, what is the best practice for implementing this?

Thank you for any insights or guidance you can provide!

[Anonymous · Accepted solution]

Hi @Acen_navadhan ,

You can filter report content by using URL filters.I ran a little test here.

Here is the original report:

To filter out the data in the table with an id of 1, append the string to the URL:

You can see that the report was successfully filtered:

You can also open the link to see more:Filter a report using query string parameters in the URL - Power BI | Microsoft Learn Here's something to keep in mind: Report URL filters have a 10-expression limit. Query string filtering doesn't work with Publish to web or Export to PDF. Embed with report web part in SharePoint Online doesn't support URL filters.

Best Regards,
Zhu
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!