Row Level security

[mstefancik]

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.

i have created test roles with rules:

Than I published it to PBI service.

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

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

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

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

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

[ganeshsanap]

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]

@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.

[GuyInACube]

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

[Greg_Deckler · Accepted solution]

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?