Forum Discussion
Handling Access to Embedded Power BI Reports using Query Parameters
- Anonymous2 years ago
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 TeamIf 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!
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!