Forum Discussion
Power Query Excel.Workbook Function - using SharePoint file and path in parameters
Hi, Paulus05 ;
For excel files storing in Sharepoint, we will use the Sharepoint Folder connector to connect to it. Based on my test, I can use it successfully when using the method provided in https://powerbi.tips/2016/09/loading-excel-files-from-sharepoint/, please check your Site URL, it will be in the format like below:
https://****.sharepoint.com/sites/****
Here are two method connecting to Excel file on Sharepoint, please refer to it: https://community.powerbi.com/t5/Integrations-with-Files-and/SharePoint-On-Premise-Connection-to-Excel-File/td-p/109560
Power Query SharePoint list connector - Power Query | Microsoft DocsQuick steps for connecting to SharePoint using Pow... - Microsoft Power BI Community
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Community SupportHi, Paulus05 ;
For excel files storing in Sharepoint, we will use the Sharepoint Folder connector to connect to it. Based on my test, I can use it successfully when using the method provided in https://powerbi.tips/2016/09/loading-excel-files-from-sharepoint/, please check your Site URL, it will be in the format like below:
https://****.sharepoint.com/sites/****
Here are two method connecting to Excel file on Sharepoint, please refer to it: https://community.powerbi.com/t5/Integrations-with-Files-and/SharePoint-On-Premise-Connection-to-Excel-File/td-p/109560
Power Query SharePoint list connector - Power Query | Microsoft Docs
Quick steps for connecting to SharePoint using Pow... - Microsoft Power BI Community
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.