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!



@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
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

Top Solution Authors