cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Post Partisan
Post Partisan

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 Service or Desktop ?

 

Regards,

Akash

5 REPLIES 5
Highlighted
Super User IV
Super User IV

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


---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Highlighted

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 ?

 

 

Highlighted

Hi @akj2784,

 

We are not able to define roles within Power BI Desktop for Analysis Services live connections. We need to implement RLS within on-premises Analysis Services models outside of Power BI. 

 

Reference: Tutorial: Dynamic row level security with Analysis services tabular model

 

Best regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted

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

Highlighted

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

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors