Forum Discussion
Solved
Sharepoint connection internal server error
Hi Community. Please, can you help me with the next issue? I'm working with a model that contains an excel file i share with collegues to update the info. The excel is sync on onedrive/sharepoint a...
abar33 ,
To connect to Excel stored in OneDrive for business, please get web url following the guide in this article.
To connect to SharePoint online Excel, please enter the following URL in web connector of Power BI Desktop.
https://XXX.sharepoint.com/sites/XXX/Shared%20%Documents/yourfolder/excelname.xlsx
To connect to sharepoint folder in Power BI Desktop, please get root url of your SharePoint site and enter the URL in SharePoint Folder connector, see https://powerbi.tips/2016/09/loading-excel-files-from-sharepoint/.
To connect to OneDrive for business folder, please check my reply in this similar thread.
Regards,Lydia