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!
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!
I have been using this method for quite some time now. The navigation pane, however, has been updated and I don't see a way to switch between reports. Am I missing something with this new UI?
Anonymous
With the help of Microsoft support, I've managed to bring back previous view by adding this to your URL:
"?tridentStageTwo=0".
E.g., try https://app.powerbi.com/home?tridentStageTwo=0
The reports that are based out of same datasets, for them this seems a hidden way to do the roles testing, ideally it must be given an easy way to navigate. Users wont even know there's such a way possible
