Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello Power BI Community,
I have created report A using Dataset A in Power BI Desktop and then published it to Power BI Service, in which RLS roles have been created, Role 1 and Role 2. Then I assigned a users email for both roles.
Then I have created a similar report B also in Power BI Desktop using Dataset A with Live connection.
I would like to have my users accessing report A using Role 1 and when they access report B, they should access it through Role 2. Is this possible? If not, are there any workarounds for such a case?
Thank you!
Yes, it is possible to have different roles for different reports that use the same dataset in Power BI Service.
One way to achieve this is by creating separate workspaces for each report in Power BI Service. A workspace is a shared area where you can collaborate with others to build and organize Power BI content. When you publish a report to a workspace, it becomes the primary content of that workspace.
Once you have created separate workspaces for each report, you can assign different roles to different users for each workspace. The users will then access each report through the roles associated with the corresponding workspace.
Here's the high-level process:
By creating separate workspaces for each report, you can effectively have different roles for different reports that use the same dataset.