cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
keerthig21
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

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

6 REPLIES 6
GilbertQ
Super User II
Super User II

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

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! 

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

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

 

Hi, 

I am wondering how did you achieve this. Can you please provide steps to get this working?

Thanks

Angad

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
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

Get Ready for Power BI Dev Camp

Power BI Dev Camp - September 30th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.