Forum Discussion
Row Level Security does not work in PBI Report Server using live connection from SSAS cube
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.
Hi, I did it, but it only worked on the desktop version of BI, not when I uploaded it to the server.
did you go with active connection or import ? for active connection it doesn't work for me !
It works with this logic on the desktop. Just make sure the user doesn't have admin rights.
I use direct query
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 !
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.