Forum Discussion
RLS Test As Role Unsupported
Hi alexabell ,
I can successfully test as role on my power bi service , and my dataset is in import mode. Here is my result:
You can check out these restrictions.
Below is the Microsoft’s official link:
Row-level security (RLS) with Power BI - Power BI | Microsoft Learn
Best Regards,
Xianda Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Yes thank you I was running in to limitation
- The Test as role/View as role feature doesn't work for DirectQuery models with single sign-on (SSO) enabled.
Does RLS work with composite models? I have both imported and direct queried data in my dataset. I'm applying the RLS to imported data, but when I have team members view the report, they can see all the rows and not just the limitations I imposed. The "View As Role" works in the PBI desktop as intended so I know the security was written correctly.
Hi alexabell ,
It is possible to configure RLS for imported data in mixed mode, and below is a graph of the results I tried to test：
RLS is available for the viewer role in workspace.
Below is the Microsoft’s official link:
Row-level security (RLS) with Power BI - Power BI | Microsoft Learn
Best Regards,
Xianda Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi alexabell ,
Please tell me have you solved the problem?
Best Regards,
Xianda Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.