Excel - Connect to a folder using online link

[JonasCosta]

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 can I do the same, but to a folder ?

I can Only connect to a local folder >> Folder.Files("C:\Users..... To reald all files inside. 

The problem with local path is that the query works only in my PC. IF I try in another one, i have to change the path.
I think online Path can solve this. 

I Can't find Shapoint Option to connect to:

[v-nmadadi-msft]

Hi @JonasCosta 

As we haven’t heard back from you, we wanted to kindly follow up to check if the suggestions  provided by the community members for the issue worked. Please feel free to contact us if you have any further questions.

Thanks and regards

[v-nmadadi-msft]

Hi @JonasCosta 

May I check if this issue has been resolved? If not, Please feel free to contact us if you have any further questions.

Thank you

[v-nmadadi-msft]

Hi @JonasCosta 

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.

Thank you.

[BA_Pete]

Hi @JonasCosta ,

In the Get Data dialog, use the SharePoint Folder connector.

In Excel, you can get there like this:

Pete

[JonasCosta]

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 ?

[BA_Pete]

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
    Source

Pete

[JonasCosta]

Thaks! I'll try and let you know. 
The Excel version is exactly the same!