Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
We are currently evaluating Power BI Server to see if we could use it in our organization.
We have over 300 stores that all connects to the company intranet application, and we would like to create reports using PowerBI to embed them to the intranet, and allow our users to visualize all sorts of data. Each store must see only their data, and under no circumstances should they be able to see other stores data.
To begin our testing, we have created a PowerBI report that displays sales data. This data comes from a single database that contains sales for every stores.
What I have tried so far is via the iframe method recommended here :
https://docs.microsoft.com/en-us/power-bi/report-server/developer-handbook-overview
It works well to display the report, and I can filter to only a single store with URL parameters.
However, the filter panel can be displayed and I could see the data of other stores.
Does PowerBI report server have a way of hiding the filter panel ? I have tried this to no success :
Another solution I can see would be to create a report per store and code the store number in the report data source. But given the number of stores and the number of reports we plan to make, this would quickly become unmanageable.
Unfortunately, embedding reports to our Intranet is a requirement for our company. If there is a viable solution, we are open to trying it out.
Thanks
Hi @gmunro,
It's not supported to hide filter pane in report server currently. In your scenario, to create one report and limit each user only see his/her own data, we can limit you can implement row level security with windows authentication all the way through the database for example (https://docs.microsoft.com/en-us/sql/relational-databases/security/row-level-security) as suggested by @jtarquino here: https://community.powerbi.com/t5/Report-Server/RLS-In-PowerBi-On-Prem/m-p/295252/highlight/true#M181...
Also you can vote on this same idea: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/31122463-dynamic-row-level-securi...
Best Regards,
Qiuyun Yu
User | Count |
---|---|
12 | |
9 | |
5 | |
4 | |
1 |
User | Count |
---|---|
19 | |
15 | |
3 | |
2 | |
2 |