Dynamic RLS

[Anonymous]

Hello,

I need to implement Dynamic RLS.

I have two tables in my report like this 

User table and Reporting table. User table have fields like BU, Usename anf other userinformation. Reporting table have fields like BU, date and other reporting information.

I have join two table By BU using many to many relationship and cross filter direction-> Both

How to implement RLS here. so that specific user of that BU can see the BU level data from reporting table.

[v-xiaoyan-msft · Accepted solution]

Hi@Anonymous ,

You can use Dynamic row level security in Power BI using DAX USERNAME() or UserPrincipalName() function.

However, you need to make sure that your Power BI model has a relationship set up properly. Otherwise, people might see other table’s data when there is no relationship between their profile table to those tables.

Dynamic row level security is highly dependent on your data model, so keep your data model right.

For more information，you can refer to this：

Dynamic-row-level-security-with-power-bi-made-simple  

You can also follow the tutorial below ：Dynamic Row Level Security with Manager Level Access in Power BI 

Hope it helps.

Best Regards,
Caitlyn Yan

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , Have you already explored these two and they are not helping?

https://radacad.com/dynamic-row-level-security-with-organizational-hierarchy-power-bi
https://www.blue-granite.com/blog/using-dynamic-row-level-security-with-organizational-hierarchies

[Anonymous]

Hello @amitchandak ,

I have added simply the Dax on my User Table

[UserName] = UserName()

but its not working.

I need to filter the data using the specific BU if the person of that BU logins