Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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:
Please mark the post as a solution if my comment helped with solving your issue. Thanks!
Proud to be a 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:
Please mark the post as a solution if my comment helped with solving your issue. Thanks!
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! 🙂
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.