Test RLS in Power BI Online with connection to another dataset
Hello,
Before I could test security roles in Power BI Online, for reports connect to other datasets, by selecting test roles in the dataset and using the left pane navigation to select the report that I wanted to test and was able to validate security in all reports connected to that data model.
Currently, I cannot find that option or another similar solution.
Can you please support?
2 Comments
bjkoning-binceAdvocate I
Hi Anonymous,
This seems to be "by design", read more here: https://community.fabric.microsoft.com/t5/Issues/No-longer-able-to-test-RLS-of-multiple-reports-with-a-shared/idc-p/3143613/highlight/true#M93062
There is an Community Idea made to bring this back: https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=944c5cef-fdc7-ed11-9ac4-281878deecac).
However: with the introduction of the new white/grey UI (the one where the icons have no colors anymore), it seems that you can workaround this by clicking the report you want to test (it now appears as last icon 'quick link'/recently accessed in the left menu), going back to the dataset to test as role and than selecting the report from the menu again (see https://community.fabric.microsoft.com/t5/Issues/No-longer-able-to-test-RLS-of-multiple-reports-with-a-shared/idc-p/3251030/highlight/true#M95835). This worked for me.
However, it seems you suggest to be able to test "all reports connected". To my best of knowledge, only reports connected to the dataset in the same workspace as the dataset were accessible in this way.
Cheers,
Bart