cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Test RLS with Power BI Service Live Connection

Hi,

 

How can I test the Row Level Security (RLS) in the report that uses Power BI Service Live Connection? Please let me know.

 

Regards,

Keerthi

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User IV
Super User IV

Re: Test RLS with Power BI Service Live Connection

Hi there

From my understanding the only way to test when connecting using a Live Connection is with the actual user logging in.

If it works successfully for one user, it should then work for the others.




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

Proud to be a Super User!







Power BI Blog

View solution in original post

5 REPLIES 5
Highlighted
Super User IV
Super User IV

Re: Test RLS with Power BI Service Live Connection

Hi there

If you are the author you will always be an admin and see all the data.

You would need to connect with another user who has got RLS applied.

I do know that RLS will apply to the dataset if you do a Live Connection and even via Analyze in Excel.




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

Proud to be a Super User!







Power BI Blog

Highlighted
Frequent Visitor

Re: Test RLS with Power BI Service Live Connection

Hi,

 

Thank you for the response. Generally I test the RLS in Power BI service using Test as Role feature and view as an actual user. But when I use Test as Role on the data set, I am not getting any option to see the behaviour of the other reports that use this data set using Power BI service live connection. I tried connecting as other test user and it works but I want to test it as a real user.

 

Appreciate your help! 

Highlighted
Super User IV
Super User IV

Re: Test RLS with Power BI Service Live Connection

Hi there

From my understanding the only way to test when connecting using a Live Connection is with the actual user logging in.

If it works successfully for one user, it should then work for the others.




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

Proud to be a Super User!







Power BI Blog

View solution in original post

Highlighted
Frequent Visitor

Re: Test RLS with Power BI Service Live Connection

Thank you. This is helpful!

I am logging in as actual user to test and also I added a table visual to the report that has the data model and testing the RLS for different roles using it.

Regards,

Keerthi

 

Highlighted
Super User IV
Super User IV

Re: Test RLS with Power BI Service Live Connection

Awesome, glad you got it working and you could test successfully




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

Proud to be a Super User!







Power BI Blog

Helpful resources

Announcements
Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Power Platform 2020 release wave 2 plan

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors