Solved: Dynamic RLS With Distribution List using office 36...

ferhat_lyes · ‎01-16-2023

Hello fellas !

I'm searching a solution to use RLS with Distribution List. i have tried to use the function dax userprincipalname() but it does not work with the Distribution List. and i don't want to creat many roles.

Clould you help me please.

Thx 😄

otravers · ‎01-16-2023

Are you sure it's a distribution list and not a Microsoft 365 group? The former should work, the latter doesn't:

https://www.oliviertravers.com/row-level-security-rls-business-intelligence/#12_Map_Roles_to_Groups_...

------------------------------------------------
1. How to get your question answered quickly - good questions get good answers!
2. Learning how to fish > being spoon-fed without active thinking.
3. Please accept as a solution posts that resolve your questions.
------------------------------------------------
BI Blog: Datamarts | RLS/OLS | Dev Tools | Languages | Aggregations | XMLA/APIs | Field Parameters | Custom Visuals

View solution in original post

otravers · ‎01-16-2023

Are you sure it's a distribution list and not a Microsoft 365 group? The former should work, the latter doesn't:

https://www.oliviertravers.com/row-level-security-rls-business-intelligence/#12_Map_Roles_to_Groups_...

------------------------------------------------
1. How to get your question answered quickly - good questions get good answers!
2. Learning how to fish > being spoon-fed without active thinking.
3. Please accept as a solution posts that resolve your questions.
------------------------------------------------
BI Blog: Datamarts | RLS/OLS | Dev Tools | Languages | Aggregations | XMLA/APIs | Field Parameters | Custom Visuals

Dynamic RLS With Distribution List using office 365 group

Helpful resources

Microsoft Fabric Learn Together

Power BI Monthly Update - April 2024

Fabric Community Update - April 2024