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 wrong or is this an issue?

 

Thank you,

6 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    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 Microsofts 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.

    • alexabell's avatar
      alexabell
      Frequent Visitor

      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

        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 Microsofts 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.

  • Brunner_BI's avatar
    Brunner_BI
    Impactful Individual

    Very strange, have never seen this before. Do you have full rights in the workspace?

    Maybe raise a support ticket if nobody can help.

  • alexabell's avatar
    alexabell
    Frequent Visitor

    Yes, I am an Admin in the workspace. Is it possible that my company administration stilll restricts my user abilities?