Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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.

Cant connect to Excel file in SharePoint Online (Office 365) using guest account

A client has created a Site/Group in SharePoint Online (SPO) and added my account as a Guest user (I have a separate Office 365 tenant & domain).  I can use the SPO web UI to navigate to the site, sign in and open an Excel file.

 

But in Power BI Desktop, I cannot use my account to refresh a Query connected to that file. Entering the credentials works fine, but refreshing the Query throws an error:

 

DataSource.Error: SharePoint: Request failed: https://...

Details:
DataSourceKind=SharePoint
DataSourcePath=https://...

 

SPRequestGuid=e0a8309e-307a-4000-e316-855d72c30b91

 

If I log in using one of the accounts in the clients domain it all works OK.

 

Please make connections to files in SPO work for guest accounts.

Status: New
Comments
v-qiuyu-msft
Community Support

Hi @mike_honey,

 

I have sent a email to consult this issue from PG team internally, will update here once I get any information. 

 

Best Regards,
Qiuyun Yu