Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Hi @omillzy ,
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:
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!
If I go to datasource it says entire organisation has Build permission, I have the option to add reshare, but not read?
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
Hi @omillzy ,
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!
Hi Kelly,
The users are added to our tenancy in 365, and I have ensured that "Allow all users to connect to the underlying datasets using the Build permission." is ticked for both apps.
However, I am still getting the permissions error. It's strange because we have an older dataset that is shared across 2 workspaces/apps and users are not receiving the permissions error. The permissions settings are all the same.
But since the November or maybe December power bi upgrade we are now having this issue with newly created shared datasets - is it possibly a bug with reports generated from one of the latest Power BI updates?
Hi @v-kelly-msft - this issue was never resolved
I found this page on microsoft documentation which explains why it's not working: https://docs.microsoft.com/en-us/power-bi/connect-data/service-datasets-share
"If you select Entire organization, then no one in the organization will have Build permission. This issue is already known. Instead, specify email addresses in Specific individuals or groups. If you want your entire organization to have Build permission, specify an email alias for the entire organization."
Both App A and B are open to 'Entire organisation' therefore no users have access to the shared dataset (although I think is counterintuitive to be honest). The solution says that I need to create an alias for the entire organisation - does anyone know I do this?
Hey @omillzy
What datasource you are using in workspace/App A?
Thanks
Jay Patel
iXpert Analytics
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
Hey @omillzy
are both the workspaces modern workspaces or 1 is modern and other is classic?
https://www.dynamicpeople.nl/en/news/sharing-datasets/#
this can also can have an impact on the issue
Did I answer your question? If Yes Please mark this as solution to help others
Best Regards
Jay Patel
iXpert Analytics
They are all modern workspaces
Hi @omillzy
Try this please:
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
Both workspaces are open to the entire organisation
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.