cancel
Showing results for 
Search instead for 
Did you mean: 

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
Moderator

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