Forum Discussion

Jeanxyz's avatar
Jeanxyz
Icon for Power Participant rankPower Participant
4 years ago
Solved

grant access to a front-end data model

Hi, 

 

I have created a frontend PB report based on backend Power BI report. the two reports are stored in different workspaces. I understand from Microsoft document that in order to give users access to the front-end report, i also need to give them access to the backend model. 

 

However, some users can open the front-end report even though they don't have access to the backend report. What's the possible reason here?

 

  • Hi Jeanxyz 

    Much depends here on the methods used to share the Report.

    If you have Dataset D in Workspace A, and Report R in Workspace B. You can share Report R via the share dialog with users and it will appear in their "Shared with me" area. They will be able to view the Report, without you implicitly giving them access to Dataset D. The share mechanism will automaticly set  "Read" and optionally "Build" rights for the users you share with to Dataset D.

    So you may have just shared the Report R with users thinking you need to set permissions on Dataset D, but find you don't need to because its done automaticaly.

    On Dataset D, go to the Dataset Options (three dots) and "Manage Permissions" you will there see who has access to the Dataset, and what rights they have. Users you have shared Report R with will appear there.

    Hope this helps

    Stuart

     

2 Replies

  • Burningsuit's avatar
    Burningsuit
    Icon for Resident Rockstar rankResident Rockstar

    Hi Jeanxyz 

    Much depends here on the methods used to share the Report.

    If you have Dataset D in Workspace A, and Report R in Workspace B. You can share Report R via the share dialog with users and it will appear in their "Shared with me" area. They will be able to view the Report, without you implicitly giving them access to Dataset D. The share mechanism will automaticly set  "Read" and optionally "Build" rights for the users you share with to Dataset D.

    So you may have just shared the Report R with users thinking you need to set permissions on Dataset D, but find you don't need to because its done automaticaly.

    On Dataset D, go to the Dataset Options (three dots) and "Manage Permissions" you will there see who has access to the Dataset, and what rights they have. Users you have shared Report R with will appear there.

    Hope this helps

    Stuart

     

  • v-henryk-mstf's avatar
    v-henryk-mstf
    Icon for Community Support rankCommunity Support

    Hi Jeanxyz ,

     

    Based on your description, I think there are some concepts you need to understand better:
    For backend data source access permission means whether there is build dataset permission or not. Having build permission allows you to create different reports on different workspaces on the basis of this dataset.

    But for report access or edit permission, it depends on whether you have edit permission or not, which depends on the permission setting in the sharing process and has nothing to do with whether you have build permission for the dataset.

    related document link:

    Build permission for shared datasets - Power BI | Microsoft Docs

    Share Power BI reports and dashboards with coworkers and others - Power BI | Microsoft Docs


    If the problem is still not resolved, please point it out. Looking forward to your feedback.


    Best Regards,
    Henry


    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.