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
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

July 2020 Community Highlights

July 2020 Community Highlights

Learn about the exciting things that happened in July.

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

We are thrilled to announce we will begin running a monthly webinar series named Power BI Dev Camp.

Power BI Desktop August 2020 Update

Power BI Desktop August 2020 Update

We have great updates this month! Click the link for the video with more info.

Top Solution Authors
Top Kudoed Authors