Row Level Security messing up filtering

[Anonymous]

Hello,

I have an issue when using RLS on my dashboard.
I have a visual that shows all the possible statusses of a product combined with the amount of products that have that status. I also have 2 filters. one of the filters is a project filter, and the second one is a user filter
A product can be assigned to either a user, a project or both.

The filter i use in the DAX expression for RLS uses the company_id to filter the data. The issue i have is when i enable RLS, the visual becomes empty. I have been doing some testing, and when i disable the RLS for the project filter, the visual shows somewhat correct data. 

is there a way to fix this behaviour, so the visual shows the data instead of becoming empty?

Thanks in advance!

[negi007]

@Anonymous can you pl. share your powerbi file if possible. You can put dummy data instead of your senstive data.

[Anonymous]

@negi007 I am unable to share the file unfortunatly. if u can tell me what u would like to see, i can provide screenshots if needed.

[negi007]

@Anonymous it seems like there is an issue the way RLS has been implemented as of result user is not able to view the data. Please note that RLS when implemented filter the data according to the role assigned to the users. I would suggest you to share your PBI file or some screenshot of your file. This will help us to understand the issue.

below are some links which can guide you on this.

https://docs.microsoft.com/en-us/power-bi/admin/service-admin-rls

https://docs.microsoft.com/en-us/power-bi/guidance/rls-guidance

https://radacad.com/what-do-you-need-to-implement-dynamic-row-level-security-in-power-bi

[Anonymous]

@negi007 

[Anonymous]

@negi007 

I have some screenshots here:

Sorry for the weird language, i am dutch 😛

The 1st screenshot shows the data when there is no RLS applied. 
The 2nd screenshot shows the way i implemented the RLS. each table has their own "bedrijf_id".

the 3rd screenshot shows what a certain customer would see. This is all their products.

the 4th screenshot shows what the customer sees when the RLS for the users is activated.

And the 5th screenshot shows what happens when the RLS for the user and the projects are enabled. Almost gets rid of all rows.