How to test RLS for all reports that share a single dataset?

[Anonymous]

Hi All,

I have a single shared dataset that feeds 7 separate reports (A, B, C, D, E, F, and G). 

Report A contains the actual dataset.

Reports B till G reference Report A's dataset.
Each report's RLS setup should be the same. If I go to the Dataset's security settings and click on "Test as role", it always takes me to Report A. This means I can positively confirm that my RLS rules are working for Report A, but how can I do the same for Report B till G?

The below screenshot shows the role that I have created in the PowerBI desktop.

I have then assigned a Member to this Role in Power BI Service

and when I try to test this role in the Power BI service, I am only able to see Report A which has 2 pages (Order Trends and Booking Protect). Now how can I also test other Reports which share the same dataset and are published in the same workspace as Report A?

I have come across a similar post where the solution says
"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. "
But I am not sure what exactly this means as there is no "Security" option for other reports (it shows only for dataset).

Also, what about those members whom I don't want to restrict with RLS security, they are being given access to the App and Workspace but not added in RLS Role, they face the below error.

Any help would be appreciated. Thanks

[GilbertQ · Accepted solution]

Hi @Anonymous 

When having a single dataset you can only test RLS on Report A in the Power BI Service.

To test the other reports would would need to log in with a user who has got access via RLS.

For people who you would want to view all the data, create a role called All, this role would then have NO filters. And then add those people to those roles.

[GianlucaM]

Hi All, is this still the state of the Art?
I find this unbeliaveble as I have the need to test different report and seems to be crazy that I cannot do it.
The alternative is to create one dataset for each report, which again is really not that brilliant in terms of platfom efficiency.
Thanks for the feedback

[Anonymous]

@GilbertQ 
Thank you so much