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,
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 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.