Dataset access

[brianlarson]

User x is able to open a report called DataSet A on PBI desktop.  DataSet A is used as the data source for Report B.  User x is unable to open Report B on the desktop.  This is the error.

Unable to connect. We encountered an error while trying to connect.  Details:  Looks like we were unable to access the dataset.  Please contact the owner of the dataset. 

How can this be possible? DataSet A is published on the PBI service.  User x is granted access to the workspace and the report and the dataset as a member.  

[brianlarson · Accepted solution]

The problem is no longer occurring.  I'm not sure if this fixed it, but I added user x to the data source in app.powerbi.com (click the cog and go to manage gateways).  

[Anonymous]

HI @brianlarson,

Can you please share some more detail about the user and report dataset permissions settings? They will help us clarify and troubleshoot these scenarios.

How to Get Your Question Answered Quickly  

Manage dataset access permissions - Power BI | Microsoft Docs
Regards,

Xiaoxin Sheng

[brianlarson]

User x is a member of the workspace, dataset, and report.  It's a windows AD account.  What other settings are there?

[Anonymous]

HI @brianlarson,

AFAIK, power bi service works with Azure AD accounts.

Sign up or purchase the Power BI service as an individual - Power BI | Microsoft Docs

As you said, the user is working with windows AD accounts that may not able to be worked as credentials when you get data from the power bi service dataset.

In my opinion, I'd like to suggest you change to the Azure AD account and try again.

Regards,

Xiaoxin Sheng

[amitchandak]

@brianlarson , What kind of role user A have been given in the workspace , I doubt that

https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-roles-new-workspaces