DataSource.Error: SharePoint: Request failed for an Excel file on OneDrive for Business

[pfurbish]

Yesterday I started getting the following error in the Power Query Editor (desktop):

Unable to Connect

We encountered an error while trying to connect.

Details:DataSource.Error: SharePoint: Request failed: ...' 

The data source is an Excel file on OneDrive for Business (multiple files).  The data connections have been live for months and just started failing yesterday without any changes to the data source parameters. I believe it is an issue with Power BI for Desktop since I can still perform a data refresh from the Power BI service.  I cleared the Power BI desktop cache.  I also signed out of Power BI, restarted my PC then signed back in to Power BI.   I do not have any issue accessing the Excel files from OneDrive for Business - online or from Excel on my PC.  I'm using the same Microsoft account for Power BI and OneDrive for Business.

[pfurbish · Accepted solution]

I worked on this issue today.  I uninstalled Power BI June release, installed the Power BI May release, then I was able to connect to my Excel files on OneDrive for Business.  Interestingly, I was reprompted for my SharePoint credentials when I opened the Query Editor.  I think the issue was caused by the way the credentials were stored.  So I re-installed the June release and the issue has not returned.