Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
mstefancik
Advocate II
Advocate II

Row Level security

Hello,

I used rls when it was not available in desktop. It worked as expected.

Today I recreated the same rules in the newest PBI desktop version and published to service myworkgroup space.

Now it does not work as expected.

 

I have simple security table to show categories based on logged on user.

table.PNG

 

i have created test roles with rules:

rules.PNG

Than I published it to PBI service.

Before adding users to roles. I test it via test role as in service.

rules service.PNG

 

I get the correct chart, showing only data for 2 categories: bikes and clothes

chart.PNG

Then I add my account to roles by choosing email address from the list.

user.PNG

 After adding account to rule, I open the report and expect the same result. But now i get the results for all categories.

chart2.PNG

Could anybody explain me why? What have i done wrong? As I have just replicated the same from service to desktop.

 

Why is it not working as expected now?

 

Thx

1 ACCEPTED SOLUTION
Greg_Deckler
Super User
Super User

Hmm, I was just testing this yesterday with a customer and it worked as expected. The main difference I see is that I added a different account to the role, not my account to the role. Perhaps as the owner/author of the report you have access to everything despite row-level security?


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

4 REPLIES 4
ganeshsanap
New Member

If you publish your Power BI Desktop report to a workspace within the Power BI service, the roles will be applied to read-only members. You will need to indicate that members can only view Power BI content within the workspace settings.

 

Note: If you have configured the workspace so that members have edit permissions, the RLS roles will not be applied to them. Users will be able to see all of the data.


Read more at: Using RLS with workspaces in Power BI 

ankitpatira
Community Champion
Community Champion

@mstefancik @Greg_Deckler that is right. as owner of the report you get access to everything regardless of RLS. you need to add another user to the role and share. when shared user opens report it will be filtered based on condition.

That makes sense. I'll be sure to call that out in the docs.

Adam W. Saxton | Microsoft Employee | Business Intelligence
@GuyInACube | youtube.com/guyinacube
Greg_Deckler
Super User
Super User

Hmm, I was just testing this yesterday with a customer and it worked as expected. The main difference I see is that I added a different account to the role, not my account to the role. Perhaps as the owner/author of the report you have access to everything despite row-level security?


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors