The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
I have a web app. there is a power BI report embedded in it. whenever a user runs a report, a unique reportid is generated. The datasource is a sql db. I want to show the user the data for only that particular report id for their run.
Currently the report shows all the data that's in the SQL db. the report id generated is also stored in the database. how can i put this filter on the report through SQL or power BI. It's a direct query report.
Solved! Go to Solution.
Hi @Rakshana,
Thanks for the great question. What’s happening is that your embedded Power BI report is currently showing all the data, because it is not being filtered by the unique ReportID generated during a user’s run.
To solve this:
If you want to enforce security at the dataset level, consider implementing dynamic Row-Level Security (RLS) and passing the ReportID as an identity claim in the embed token using the GenerateToken API.
Kindly refer to the below mentioned documentation links for better understanding:
Use filters in a Power BI embedded analytics report | Microsoft Learn
Using standard cloud based row-level security with embedded content in Power BI embedded analytics -...
Hope this helps clarify things and let me know what you find after giving these steps a try happy to help you investigate this further.
Thank you for using the Microsoft Community Forum.
Hi @Rakshana,
Thanks for the great question. What’s happening is that your embedded Power BI report is currently showing all the data, because it is not being filtered by the unique ReportID generated during a user’s run.
To solve this:
If you want to enforce security at the dataset level, consider implementing dynamic Row-Level Security (RLS) and passing the ReportID as an identity claim in the embed token using the GenerateToken API.
Kindly refer to the below mentioned documentation links for better understanding:
Use filters in a Power BI embedded analytics report | Microsoft Learn
Using standard cloud based row-level security with embedded content in Power BI embedded analytics -...
Hope this helps clarify things and let me know what you find after giving these steps a try happy to help you investigate this further.
Thank you for using the Microsoft Community Forum.
thank you so much. we passed a filter parameter in the web app. It worked