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://...





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

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