Forum Discussion
Excel - Connect to a folder using online link
When I connect Power Query to a .XLSX file, I can open it and copy the path ("https://xxxxxx.sharepoint.com/sites/") Then in the PQ: "Excel.Workbook(Web.Contents("https://xxxx.Sharepoint....)" How ...
Hi JonasCosta ,
In the Get Data dialog, use the SharePoint Folder connector.
In Excel, you can get there like this:
Pete
Hello BA_Pete !
Thank you for your answer!
I can't find the "From sharepoint folder" option.
Maybe that's something related with my Office Version. I'm using Microsoft 365.
I looked for some option to enable but cant't find.
Do you know something abou that ?
Hmm, that's odd. I would have thought your Excel would auto-update if you're on M365.
Here's the version I'm using for reference:
And here's the basic connection string that PQ generates to connect to a folder, so you can try just copy/pasting into Advanced Editor:
let Source = SharePoint.Files("https://ORGNAME.sharepoint.com/sites/SHAREPOINTSITENAME/", [ApiVersion = 15]) in SourcePete
Thaks! I'll try and let you know.
The Excel version is exactly the same!