Blog Post

Power BI Community Blog
3 MIN READ

Different approach to Dynamic Row Level Security

jirineoral's avatar
jirineoral
Post Patron
9 years ago
There were already written few blog posts both about Row Level Security. I would like to add one more about this topic. I use this pattern for several years in SQL Server Analysis Services. Biggest a...
Published 9 years ago
Version 1.0
How To
RLS
Tips & Tricks
jirineoral's avatar
Post Patron
Joined October 21, 2015
View Profile
Power BI Community Blog
Explore how-to guides, expert tips, and insights on Fabric Data Warehouse, featuring advice from Microsoft experts and leading community contributors. If you are interested in becoming a community blog author, send a private message to Natalie_iTalent. An overview of the community blogs can be found here.
ypradeep23's avatar
ypradeep23
Advocate I
9 years ago

jirineoral. Sorry for the spam. Have few updates. Let me summarize my approch.

 

Data Source: I have 2 entities in On-Prem SQL Server

  1. Customer (ID, CustomerName, Revenue, Area, Subsidiary, Country)
  2. ManagerPermission (Alias, Email, Country)

Report: Created Report in Power Bi Desktop with "Import" option. Create a new role called "DynamicRLS" with expression on "Customer" entiry.

 

NOT(ISBLANK(LOOKUPVALUE(ManagerPermission[Country],ManagerPermission[Country],[Country],ManagerPermission[Email],USERNAME())))

Published Report to online, but not able to see any data in report as other user. Then I added an security group explicitly to Role (Dataset > Security > Row-Level Security > DynamicRLS). Now, able to view report w/ filtered data, as expected. Thank you for your post, Very helpful.