Power Platform Community Forum Thread Details

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

Categories:

General topics