RLS giving fill access to users for different reports

[supergallagher25]

Hello,

I have an email group for Managers from different companies that I am setting up dashboards for. I have tied the managers to the reports that I create for just their companies. I only have one email security group irrespective of the companies they are in. When I test their permissions for their reports , I can see that they can only see what I have permitted them to see. Their users ID’s are tied to the company that they are working on.

However, since they have the same email group, when I share it with all of them, managers from other companies can view dashboards of different companies with no limitations which they should not be allowed to. Can somebody please tell me how somebody from Company A and view everything from the dashboard created for Company B? Isn’t it supposed to show restricted data instead?

[Rajesh]

Hi @supergallagher25

Please share pbix file with sample data.
Did you create any roles in Desktop ?

Here is the link to get some idea on RLS

RLS for an Org hierarchy

Hello I am getting myslef familiarized with the Power BI RLS functionality. I need to develop a dynamic security set up for the model being built. The ask is to have the report be viewed by only the Managers or superiors who are part of the hierarchy. My model has a shipment table with managers responsible. These managers have superiors as SVP’s and their superiors as Presidents. The shipments data will have the President’s ID’s, but in the future could have the SVP id as person responsible fo…

[EnterpriseDNA]

Thanks for posting your question @supergallagher25. To receive a resolution in a timely manner please make sure that you provide all the necessary details on this thread.

Here is a potential list of additional information to include in this thread; demo pbix file, images of the entire scenario you are dealing with, screenshot of the data model, details of how you want to visualize a result, and any other supporting links and details.

Including all of the above will likely enable a quick solution to your question.

[EnterpriseDNA]

Hi @supergallagher25, we’ve noticed that no response has been received from you since the 11th of September. We just want to check if you still need further help with this post? In case there won’t be any activity on it in the next few days, we’ll be tagging this post as Solved. If you have a follow question or concern related to this topic, please remove the Solution tag first by clicking the three dots beside Reply and then untick the checkbox. Thanks!