Get all files in a folder into PowerQuery from a Sharepoint site

[andymcw]

Hi All,

Not sure whether I'm in the right place on the forum. If not can someone signpost me please.

I'm trying to import 'all files in a given folder' as a Source for a PowerQuery. I can do that if the folder is local, but I want to do it from our organisation's sharepoint site so that others can use the PQ. 

If I do Source = Files.Folder (" <pathname>") with a sharepoint folder path starting https:// then I get an invalid pathname diagnostic. I guess Files.Folder expects a local pathname.

If I do Source = Web.Contents(" <pathname>") then that seems to be accepted but then I run into an authentication issue. I have selected Organisational Account and signed in with my corresponding username. But keep getting the authentication failure when I try to connect.

What am I doing wrong? Or am I trying to do the impossible?

Thanks,

Andy