Blog Post

Power BI Community Blog
3 MIN READ

Different approach to Dynamic Row Level Security

jirineoral's avatar
jirineoral
Icon for Post Patron rankPost Patron
10 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 10 years ago
Version 1.0
How To
RLS
Tips & Tricks
jirineoral's avatar
Icon for Post Patron rankPost Patron
Joined October 21, 2015
View Profile
Power BI Community Blog
On this blog you will find articles, guides and information created by our community members and, from time to time, roundups and community news. 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
Icon for Advocate I rankAdvocate 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.