Forum Discussion
Error loading Excel file from Sharepoint
I get an error when loading the file into PowerBI. I've tried multiple times and consistently get this error:
Please try again later or contact support. If you contact support, please provide these details.
11 Replies
Hi jamieo,
How do you connect to the Excel file in Power BI? Please make sure that you go to “Get Data>Files>SharePoint -Team Sites” and enter the URL of SharePoint Site, then choose the target Excel to connect to.
In addition, you can use Power BI Desktop to connect to Excel stored in SharePoint and check if it is successful. In Power BI Desktop, use “Get Data>Web” option and enter URL of Excel file.
Thanks,
Lydia ZhangI am having the same issue. I tried to connect to an Excel file hosted on a SharePoint Site. I selected Get Data-->File-->Excel. The File selection window opens then.
In the path I put: https://XXX.sharepoint.com/sites/XXX/Shared%20%Documents/XXX/data/prod/
When I click enter I do get the following error message in Power BI Desktop: Windows can't find
https://XXX.sharepoint.com/sites/XXX/Shared%20%Documents/XXX/data/prod/. Check the spelling and try again. The path is correct. I tried the same path in Excel 2016 Power BI and it works seemless.
I then connected to the file using Get Data-->Web and put in the full SharePoint Path. Power Bi Desktop was able to connect the file after provding Organizational Credentials for the Connection. That worked so far.
Now I published the Power BI Desktop Report to Power BI Online.
The problem now is that Power BI App cannot connect to the data files (and hence not schedule refreshes). I do get the same error message like jamieo.
Your data source can't be refreshed because the credentials are invalid. Please update your credentials and try again.
Activity ID: 0430926a-98ae-4fb1-9797-aa0da2fa0b27 Request ID: eb024ef8-941a-5643-9aa8-1136d7b5933c Status code: 200 Time: Thu Aug 18 2016 11:29:44 GMT-0400 (Eastern Daylight Time) Version: 13.0.1605.328 I have the option to enter credentials for the web URL. However, the problem is that only Anonymous, Windows, Basic and oAuth2 are available but not Organizational Account.
How can I solve this issue either changing the initial connection method (I don't have the option Get Data-->Files-->SharePoint-Team Sites by the way in Power BI Desktop) or the authentication in the Power BI App?
I did as you say to connect to the document and was able to see and select the desired Excel file, just not load it.
If I do as you suggest, would I still be able to refresh the dataset when published to PowerBI.com?
Hi jamieo toulou,
When you connect to Excel file from Sharepoint Online in Power BI Desktop, create PBIX file and publish it to Power BI Service, you are able to schedule refresh for the dataset.
Moreover, OAuth2 is the right protocol for SharePoint Online Excel, there is no other option to connect to the web URL besides those options mentioned by toulou.
Thanks,
Lydia Zhang
Will data imported from "Get Data -> Web" refresh correctly? It seems to be working but I haven't been able to test refresh yet.
