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!
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
Unfortunately, it appears this solution also no longer works.
Here's a little workaround that I just stumbled over:
1. Try to first open the desired report in a new window.
2. Now open security settings of the shared dataset, choose a role and choose "test as role" from the 3 dots menu
Now the test-as-role mode opens, using the report that was opened in a new window in step 1.
Does this work for you, too? I'd be happy to know!
Cheers
Unfortunately not. When I use the test as role option, the same report always opens regardless of which report I opened in a new window in step one. The only way I have found to test the RLS settings on shared datasets is to delete all other reports except the report I want to test.
Hi, I've checked this twice during the last 2 days. It works for me when I do it this way:
(tested with Edge browser)
1. Open workspace with the desired report using "all" tab (contents + datasets)
2. Open the report to simulate in a new window
3. In this new window, go back to to the workspace using the link on the left hand side. You should see the "all" tab again
4. Go to security of the underlying shared dataset, choose a role and test it.
This might also have been working with chrome browser, but I didn't actually check this.