Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to 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.
Hello,
have you resolve the problem ! if fyes can you help me please.
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 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.
Is it multidimentionnal or tabular cube ?
Tabular
I use direct query
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
98 | |
96 | |
78 | |
72 | |
66 |
User | Count |
---|---|
136 | |
109 | |
104 | |
82 | |
73 |