Forum Discussion

abar33's avatar
abar33
Frequent Visitor
7 years ago
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...
Data Modeling
Gateways
Anonymous's avatar
Anonymous
Not applicable
7 years ago

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