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
User | Count |
---|---|
27 | |
14 | |
12 | |
10 | |
9 |
User | Count |
---|---|
50 | |
29 | |
28 | |
24 | |
20 |