Dynamic access to report based on level

[nbaraili]

Hi All,

I have RLS applied to a report based on location.
The report has level category as A, B, C, D and E . I want to have complete access to the report for A, B, C, D based on location based RLS provided, but E should see only his data to his location.

Any idea how i should take this forward ?

stay safe,
Niraj

[MK3010]

Hi @nbaraili,

You can refer to below blog we have very good discussion on this.

RLS security/Hierarchy levels

I have typical requirement. We are implementing row level security. As part of the security requirement, we would need to show/restrict few columns in dashboard. Example: When VP login to power BI, he should see column1, column2, column3, cloumn4,column5. When RL logins to power BI, he should able to see column2, column3, cloumn4, column 5. when DL login to Power BI he should able to see column3,cloumn4,column5. Do we have any dynamic conditional method in power bi based on RLS

Row Level Security and Permissions

Hi @jmolina, You can rely on the Active directory to do so. We have many great discussion on the forum. Please have a look to below link. [Scale Your Power BI Reporting With Row Level Security] Also a video from Darren which shows how to do it using DAX Studio. [Row Level Security With Hierarchies] And another one which i used recently. [Setting Up Power BI Row Level Security]

Thanks
Mukesh

[EnterpriseDNA]

Hi @nbaraili, we’ve noticed that no response has been received from you since the 16th of October. 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!

[Gifted]

Hi @nbaraili I ask you to see the link below I think it solves your problem or can give you an idea of ​​a resolution.

RLS and different currencies for diff users

Hi @jonbar123 , I ask you to see the link below I think it solves your problem or can give you an idea of ​​a resolution. [What is Row-Level Security (RLS) in Power BI???]

[EnterpriseDNA]

Hi @nbaraili, a response on this post has been tagged as “Solution”. 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 check box. Thanks!