Forum Discussion

alexabell's avatar
alexabell
Frequent Visitor
2 years ago

RLS Test As Role Unsupported

Hello Everyone,   I went to test view the report as the designated role, and I'm receiving an "Unsupported" error. My report and dataset are published in the same Workspace.  Am I doing something w...
Need Help
alexabell's avatar
alexabell
Frequent Visitor
2 years ago

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.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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.