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

[EduSurveys]

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

[Anonymous · Accepted solution]

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! 

[EduSurveys]

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

[Anonymous]

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

[GilbertQ]

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)