Forum Discussion

akj2784's avatar
akj2784
Post Partisan
8 years ago

How to Validate RLS in Power BI Desktop

Hi All,   We have some Row level security applied to roles, we want to test it using some test ids so that we don't have ask real time users to validate it.   Is there any way we can do this in S...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Community Champion
8 years ago

In the Desktop, go to the Modeling tab in the ribbon and in the Security section, choose "View as Roles"

akj2784's avatar
akj2784
Post Partisan
8 years ago

If I do the data model in SSDT, deploy it to SSAS and do a live query in Power BI Desktop, the View as feature is disabled.

And I don't see this feature in Service.

 

Is there any other way to validate it ?

 

 

    • akj2784's avatar
      akj2784
      Post Partisan
      8 years ago

      Agree. My question was more on the validation part.

      I have applied RLS in the SSDT, deployed it to SSAS.

      Now being a developer how would I test whether my implementation is correct or not. Basically Unit Testing of the code.

      Can I impersonate my id to someone else and check the data ?

       

      Or what is the way to validate such scenario.

       

      Regards,

      Akash

      • v-yulgu-msft's avatar
        v-yulgu-msft
        Microsoft Employee
        8 years ago

        Hi akj2784,

         

        Could you see the Test as a role option on service?

        1. Select the ellipsis (...) next to the dataset.
        2. Choose "SECURITY".
        3. Select the ellipsis (...) next to the role.
        4. Select Test data as role

         

        Regards,

        Yuliana Gu