Forum Discussion
Error loading Excel file from Sharepoint
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
Lydia, even going this route, the automatic refresh fails. I can manually refresh through the "Schedule Refresh" interface by manually changing to Oauth and providing credentials, but these credentials are gone the next time I login and any scheduled refresh fails.
Is there any way to get scheduled refresh without using a PowerBI Gateway?
Hi jamieo,
No gateway is required in your scenario. Power BI Service directly connect to the Excel file stored in SharePoint Online. What is the exact error message do you get when you schedule refresh?
Thanks,
Lydia ZhangEvery time I login the credentials appear to revert to "Anonymous" and the error I get during the refresh is:
```
Hide details
Data source type:Processing error:
The key didn't match any rows in the table.
Cluster URI:
DF-MSIT-SCUS-redirect.analysis.windows.net
Activity ID:
7c0c7083-e50f-4e5b-a0fd-4f06b029db04
Request ID:
ed5aa13c-4c61-4fe4-8a33-8db11624f317
Time:
2016-08-22 05:21:05Z```
p.s. Is there any way to get markdown to work in these forums?
Hi jamieo,
When entering the account and credential to configure schedule refresh in Power BI Service, do you use the same organization account that is used to connect to SharePoint Online in Power BI Desktop?
Thanks,
Lydia Zhang