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.
Thanks for the information, I will add to my learning Collection.
I believe the problem in the query I was dealing with was mostly to do with random text copy and pasted from a line in a readme document someone was working on at the same time as the query.
However, good to have your information about usinng the Sharepoint Folder connector for reference, thank you 😎