Row Level Security - Bridge Table - Best Practice

[AmritaOS]

Hi All,

I am new to RLS and need to implement it for a client report. i am looking for some advise on where to store my bridge tables? do i just create a table using DAX? save it locally on excel (i really dont want to do this), do i create it in the database? 

What is best practice? a solution that is scalable.

Thanks,

Amrita

[mohammedadnant · Accepted solution]

Hi @AmritaOS 

2 things to consider, static or dynamic,

Static = Create role in Power BI Desktop --> publish the report --> assign users manually in Power BI Service

Dynamic = a table containing user details which can linked with the other tables in Power BI Desktop --> create a role in Power BI Desktop --> assign UserPrincipalname in the role in Power BI Desktop --> publish to power bi service

If you have SQL database then I recommend, create a table for this in SQL and import, if not you can upload the excel into sharepoint from there you can connect in Power BI,

beause whenever you need to add/remove a user you can do in the online excel and it will refresh accordingly.

Hope, you have got an idea how to do, Hit like if you like the answer.

Thanks & Regards,

Mohammed Adnan

https://www.youtube.com/c/taik18

[V-lianl-msft]

Please refer to this blog:

https://radacad.com/dynamic-row-level-security-with-power-bi-made-simple 

[AmritaOS]

i have multiple users who require access to data from different states, some require only one state and some multiple. i want the RLS to be dynamic ie, pass username to determine access.

[selimovd]

Hey @AmritaOS ,

why do you need a bridge table?

What do you want to do with RLS?

Best regards

Denis