Showing results for 
Search instead for 
Did you mean: 
New Member

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

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?






Helpful resources

Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (5,542)