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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

RLS not working properly for users with multiple roles

I have a big semantic model with RLS set up.

 

Some users have multiple roles. It used to work very well and used to result in a union of what they are allowed to see based on the roles.

 

Now for whatever reason a user that has 2 roles, can't see everything he is supposed to see based on 1 of his roles. I can test it by checking a report in service with view as role and view as user. This is very confusing. Please advice!

 

Did anything change in the way RLS work with the june release?

Status: Investigating

Hi @Olala 

Based on your description , the problem seems to be with the measures you are using . Can you provide samples for reference? Or avoid using measures with crossfilter?

How to provide sample data in the Power BI Forum - Microsoft Fabric Community

 

Best Regards,
Community Support Team _ Ailsa Tao

Comments
v-yetao1-msft
Community Support
Status changed to: Investigating

Hi @Olala 

There is no known issue related to this, what do you mean by I can test it by checking a report in service with view as role and view as user ? Can you describe in detail what you mean? Are you getting the right results from the Desktop test?

 

Best Regards,
Community Support Team _ Ailsa Tao

Olala
Frequent Visitor

, I see indeed that combining 2 roles results in a wrong result, and I figured that the problem occurs in measures that use crosssell command

Olala
Frequent Visitor

it is the same on desktop.

 

Role 1:  I see nothing

Role 2: I see 7164

Role 1 + role 2: I see 6153

 

This behaviour is with measures using crossfilter

v-yetao1-msft
Community Support
Status changed to: Investigating

Hi @Olala 

Based on your description , the problem seems to be with the measures you are using . Can you provide samples for reference? Or avoid using measures with crossfilter?

How to provide sample data in the Power BI Forum - Microsoft Fabric Community

 

Best Regards,
Community Support Team _ Ailsa Tao

Olala
Frequent Visitor

Avoiding measures with crossfilter- well it is still a valid DAX formula, right?

Besides it used to work ok!