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: Something went wrong. Failed to configure selected file Please try again later...
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
yes, oAuth2 works. Although I had to open and close the browser a few times because after a few files it wouldn't work anymore. Thank you for your help.