Shared dataset between workspaces

[charlotte_13]

Hi! A little bit confused regarding how to set this up properly. 

I have a master dataset in Workspace A, then connected a report in Workspace B to this dataset. The report then is published in an app where the user access it. When user try to access the report from the App he get the message "Permission required
The content of this report cannot be displayed because you do not have permissions for the underlying dataset. Contact the owner of the dataset to request access". Do I have to give all users of Workspace B access to Workspace A where the dataset is published to get this to work out properly? Thank you!

[Daryl-Lynch-Bzy · Accepted solution]

Hi @charlotte_13 - Not quite, but yes.  You need to understand the difference between sharing App access versus Workspace access to answer your question properly.  Yes, the user will need access to the "Dataset" in Workspace A to use the App based on the Report in Workspace B.  When you share access via an app, the users will be provided access to the Datasets linked to the content, but this only happens automatically when if the Dataset is within the current Workspace (i.e. B not A).   It important to understand that you are sharing Datasets access, but not Workspace access - these are different roles/personas.   

Adam from Guy In a Cube created this video to explain this concept.  Dataset permissions required for App report in Power BI? What am I missing??? (Re-Upload) - YouTub...

I suggest using an AD Group to manage access to the App, and this AD Group can be included on the Dataset in Workspace A.

[charlotte_13]

Thank you very much!