Get data from SharePoint list folder

[GeorgilasV]

Hello,

I want to retrieve data from a SP list folder.

Neither the list connector nor the folder connector seemed to work.

I tried with OData but cannot authenticate for a weird reason.

Any ideas? Thank you 🙂

[Anonymous]

Hi,

When you connect to a Sharepoint you'll need to only use the start of the Sharepoint URL:
https://COMPANY.sharepoint.com/sites/YOURSHAREPOINT/

In Power Query you can then navigate to the folder you want to connect to. Either by the url link to the right or to change the connection type from Sharepoint.Files to Sharepoint.Contents

[GeorgilasV · Accepted solution]

That was what I was doing but I could only access the tables within the list.

The issue was that there were folders.

The solution was to use v1.0 of online lists!