Forum Discussion

utsavlexmark's avatar
utsavlexmark
Icon for Helper III rankHelper III
4 years ago
Solved

Two Dashboards in a single App

Hello All,

I have two Power Bi Dashboards (suppose Dashboard A and B) in a single app. Whoever is asking for access to any of the dashboards - I have to give them access to the app and as a result they can access both the dashboards. Now some people who are asking for access of Dashboard B should not have a access to Dashboard A as per company policy.

What can be done - so that, people asking for access of only Dashboard B should access that only - not the other one?

Regards

Utsav

  • Hi utsavlexmark ,

     

    1. You can do this by creating report across workspaces.

    Store the datasets (assume dataset A and dataset B) of dashboard A and dashboard B in separate workspaces (assume workspace A and workspace B). Then create report and dashboard A in workspace B based on dataset A. Then publish the app for workspace B. Note that dashboard A cannot be placed as the first item in the app.

    Users will encounter problems when interacting with the app: without dataset access, the report will not open and the dashboard tile will appear locked. So make sure that the users who disable access to dashboard A do not have access to dataset A.

    Here are the steps of my test.
    (1). Create report and dashboard across workspaces.

     

     

     

    (2). Publish the app and reorder the content.

     

              

     

    (3). Manage permissions for dataset A.


    (4). The users Winniz and winniz ppu access the app.

     

     

     

    2. If you want dataset A and dataset B to be in the same workspace, then I think using RLS for dataset A is an option. 

    Row-level security (RLS) with Power BI 

     

     

    If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
    Best Regards,
    Winniz
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

     

     

     

     

     

2 Replies

  • v-kkf-msft's avatar
    v-kkf-msft
    Icon for Community Support rankCommunity Support

    Hi utsavlexmark ,

     

    1. You can do this by creating report across workspaces.

    Store the datasets (assume dataset A and dataset B) of dashboard A and dashboard B in separate workspaces (assume workspace A and workspace B). Then create report and dashboard A in workspace B based on dataset A. Then publish the app for workspace B. Note that dashboard A cannot be placed as the first item in the app.

    Users will encounter problems when interacting with the app: without dataset access, the report will not open and the dashboard tile will appear locked. So make sure that the users who disable access to dashboard A do not have access to dataset A.

    Here are the steps of my test.
    (1). Create report and dashboard across workspaces.

     

     

     

    (2). Publish the app and reorder the content.

     

              

     

    (3). Manage permissions for dataset A.


    (4). The users Winniz and winniz ppu access the app.

     

     

     

    2. If you want dataset A and dataset B to be in the same workspace, then I think using RLS for dataset A is an option. 

    Row-level security (RLS) with Power BI 

     

     

    If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
    Best Regards,
    Winniz
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.