Forum Discussion
How to test RLS for all reports that share a single dataset?
hi Jhu23,
I tested the particular scenario and I am able to toggle between 2 reports - 1 built on the data model and another which is using the same data model as a shared dataset.
If you have assigned users to the different security groups then you would need to assign similar security at report level as well so users just see the report they need to see.
Please mark the post as a solution if my comment helped with solving your issue. Thanks!
hi Jhu23, Have you created seperate roles for each of the reports?
If you have the data setup correctly, you can defined a role for each report and then grant access to specific roles for each of the reports.
You can refer to the Mocrosoft Docs link for additional information:
https://docs.microsoft.com/en-us/power-bi/guidance/rls-guidance
Please mark the post as a solution if my comment helped with solving your issue. Thanks!
Sumanth - Yes, I have new roles for each report. I believe the RLS is set up correctly and that end-users will only be able to see the data that they are authorized for, however I want to be able to actually test this using the "Test as role" feature. However, I am only allowed to "test as role" for Report A, never for Reports B and C.
Greg - I am testing from the original dataset.
hi Jhu23,
I tested the particular scenario and I am able to toggle between 2 reports - 1 built on the data model and another which is using the same data model as a shared dataset.
If you have assigned users to the different security groups then you would need to assign similar security at report level as well so users just see the report they need to see.
Please mark the post as a solution if my comment helped with solving your issue. Thanks!
Thank you, Sumanth! That did the trick!
