Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Shared datasets - Permissions issue

I'm having some strange things with datasets shared across workspaces.

 

Here's an example:

 

Workspace/app A: Dataset 1, Report 1

Workspace/app B: Report 2 (using dataset 1 as datasource)

 

Both workspaces/apps are completely open to the organisation, however, when users click on Workspace/app B to visit Report 2 they get the following message:  "Permission Required: You cannot see the content of this report because you do not have permissions to the underlying dataset. Please contact the dataset owner to request access."

Surely if both Apps are open there shouldn't be any issue?

Need Help

12 Replies

  • iXpert_info's avatar
    iXpert_info
    Helper II
    5 years ago

    Hey Anonymous 

    What datasource you are using in workspace/App A?

    Thanks
    Jay Patel
    iXpert Analytics

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      We have a couple of instances where this issue is occuring.

       

      The first is an admin usage report using the Power BI rest APIs to gather information about our tenancy and refresh the schedule

      The second is just a data warehouse sql server hosted on Azure

  • v-kelly-msft's avatar
    v-kelly-msft
    Community Support
    5 years ago

    Hi Anonymous ,

     

    After testing,when you use shared dataset to create an app ,you need to grant permission of the dataset to the users who need to access:

    Things to keep in mind about publishing apps:

    • The permissions page doesn't change permission on datasets in other workspaces. You do see a warning reminding you to grant access to those datasets independently. A best practice is to contact the dataset owner before starting to build your app to ensure it is OK to give all your app users access those datasets.

    For the related reference,see below:

    https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-create-distribute-apps

     

     

     

    Best Regards,
    Kelly

    Did I answer your question? Mark my post as a solution!

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      So how can I grant access to the entire organisation? Surely I don't need to add each member individually to the dataset...We have about 500 users, constantly growing everyday

      • v-kelly-msft's avatar
        v-kelly-msft
        Community Support
        5 years ago

        Hi Anonymous ,

         

        First of all,you should be sure that the users are in your tenant(by adding them to your tenant in office 365 or Azure AD),then when you buid the app,go to permisson>Entire organization>"Allow all users to connect to the underlying datasets using the Build permission."

        App buid is different from buid permission,check the reference below:

        https://docs.microsoft.com/en-us/power-bi/connect-data/service-datasets-build-permissions

         

        Best Regards,
        Kelly

        Did I answer your question? Mark my post as a solution!

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

       

      If I go to datasource it says entire organisation has Build permission, I have the option to add reshare, but not read?