Row Level Security not working as expected

[gthebaud]

I have created a report and up until today RLS was working as usual.

The data model format is as follow:

- Base data which is the main table

- Views from the base data with different aggreagations and such

- Lookup table such as (Division, Region), Calendar etc that are each linked to the main base data or views if needed.

I have setup my basic RLS like this:

Each region is a role and I filter for it on all the necessary tables.

When I test out the RLS with the "All user", the data is correct.

However, as of yesterday if I select one region, the numbers are going to be millions instead of thousands.

  

I have checked the SQL DB and the direct query import, the data in there is correct. I believe the issue is coming from RLS. Any thougths?

[v-robertq-msft]

Hi,

What’s the user account you used to test the RLS? Did the user account has edit access to the dataset?

Because only the users who have view access to your dataset can make the RLS work on them, if they have edit access to your dataset, then the RLS won’t work on them. You can refer to this link:

https://docs.microsoft.com/en-us/power-bi/admin/service-admin-rls#using-rls-with-workspaces-in-power...

Best Regards,

Community Support Team _Robert Qin

[gthebaud]

I was able to figure it out by myself by profiling with sequel server.

A join was happening for some reason. I reworked my model and fixed it this way.

All users accessing this report only have view.

Thanks again.

[v-robertq-msft]

Thank you for the response!😁