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
