Forum Discussion

ldmass's avatar
ldmass
Regular Visitor
4 years ago
Solved

Row-level Security to Multiple Reports with Same Dataset

Hi experts, There are two reports on the same dataset, I wish to apply RLS differently on these two reports. Challenge is, since they are on same dataset, Power BI only lets me apply security at a d...
Need Help
Tips and Tricks
  • ldmass's avatar
    ldmass
    4 years ago

    Thank you all!! Although this solution could work, it is not feasible due to the creation of workareas... Finally, I am going to create copies of the reports filtered to each zone (there are 4 zone values, therefore 4 copies of the report), and will be given access as appropriate

v-kkf-msft's avatar
v-kkf-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi ldmass ,

 

A workaround is to create RLS and then place the two reports in different workspaces (A and B).

Then add the user X as an Admin/Member/Contributor of workspace A so that he can see all the data of the report in workspace A.

Then share the report in workspace B (without editing rights to the report) so that this user will only be able to see the RLS restricted content.

 

Best Regards,
Winniz

ldmass's avatar
ldmass
Regular Visitor
4 years ago

Thank you all!! Although this solution could work, it is not feasible due to the creation of workareas... Finally, I am going to create copies of the reports filtered to each zone (there are 4 zone values, therefore 4 copies of the report), and will be given access as appropriate