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
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!

Community Blog

Community Blog

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

Upcoming Events

Upcoming Events

Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.

Community Summit Australia – Join Online!

Community Summit Australia – Join Online!

Be a part of the leading Microsoft Business Applications digital event, curated for the APAC community.