cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
EduSurveys
Advocate II
Advocate II

"Test as role" in new report that uses PowerBI dataset

I have a new report (Report B) in the Power BI cloud service that uses a Power BI dataset as its data model. I have row-level security (RLS) built into that dataset, and I can "Test as role" in the original report (Report A). However, I would like to be able to "Test as role" in this new report (Report B). Is there currently a way to do that?

 

In short:

1. Report A - original dataset, can use "Test as role" by going to security settings

2. Report B - built using PowerBI dataset from Report A, cannot "Test as role" in this report

1 ACCEPTED SOLUTION
Sumanth_23
Super User
Super User

hi @EduSurveys  - you should be able to test 2 reports (1 built on the dataset and another built using the original dataset as a shared dataset)

 

Please refer to the below post for steps on doing the same: 

https://community.powerbi.com/t5/Service/How-to-test-RLS-for-all-reports-that-share-a-single-dataset...

 

Please mark the post as a solution if my comment helped with solving your issue. Thanks! 

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

Proud to be a Super User!



View solution in original post

4 REPLIES 4
Sumanth_23
Super User
Super User

hi @EduSurveys  - you should be able to test 2 reports (1 built on the dataset and another built using the original dataset as a shared dataset)

 

Please refer to the below post for steps on doing the same: 

https://community.powerbi.com/t5/Service/How-to-test-RLS-for-all-reports-that-share-a-single-dataset...

 

Please mark the post as a solution if my comment helped with solving your issue. Thanks! 

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

Proud to be a Super User!



View solution in original post

@Sumanth_23 that is definitely not intuitive from a user perspective, but your solution does work! It would be nice if the blue banner had a toggle among the shared reports. Thanks for sharing this tip!

hi @EduSurveys - Yes, I agree not really intuitive but at this point this is a way to get around that I figured for testing RLS. 

 

Happy to help! 🙂 

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

Proud to be a Super User!



GilbertQ
Super User
Super User

Hi there

The reason that this will not work is because the RLS is tied to the dataset and not to the report.

What I would say is you can test the RLS on Report A, if that works as expected. it will then work on Report B. (This is because Report B is using the dataset from Report A)




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

Proud to be a Super User!







Power BI Blog

Helpful resources

Announcements
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

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

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!