Row Level Security does not work in PBI Report Server using live connection from SSAS cube

[KEIRA]

Hello everyone,
I have a model built in SSAS.
I have done RLS in SSAS and it works successfully in Power BI desktop version.
RLS does not work when I upload the report to the server.

Can anyone suggest what could be the problem and how to fix it?

[elayda]

Hello,

have you resolve the problem ! if fyes can you help me please.

[KEIRA]

Hi, I did it, but it only worked on the desktop version of BI, not when I uploaded it to the server.

[elayda]

did you go with active connection or import ? for active connection it doesn't work for me ! 

[KEIRA]

It works with this logic on the desktop. Just make sure the user doesn't have admin rights.

[elayda]

I didn't get what did you do after roles and the expression dax, in power bi desktop can you tell me what did you do exactly please !

[KEIRA]

I did everything required for the role in SSAS, I don't do anything in BI itself.
Everything I have done in SSAS is in the photo.
After that, Everyone will see their respective data.

[elayda]

Is it multidimentionnal or tabular cube ?

[KEIRA]

Tabular

[KEIRA]

I use direct query

[Anonymous · Accepted solution]

Hi  @KEIRA ,

You can refer to the following link for the limitations of RLS in PBI Report Server:

Row-level security (RLS) in Power BI Report Server - Power BI | Microsoft Learn

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.