Embedded reports data security

gmunro — Fri, 02 Feb 2018 20:55:36 GMT

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 :

https://community.powerbi.com/t5/Service/Hiding-Report-Level-filters-in-the-Iframe/m-p/70233#M13381

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

Re: Embedded reports data security

v-qiuyu-msft — Tue, 06 Feb 2018 07:44:28 GMT

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#M1812

Also you can vote on this same idea: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/31122463-dynamic-row-level-security-for-power-bi-report-ser

Best Regards,
Qiuyun Yu

topic Re: Embedded reports data security in Report Server

Embedded reports data security

Re: Embedded reports data security