Getting a single file from a large SharePoint site

[Ian_Altis]

I have read some long threads on this topic and tried many times myself to get a single file from a huge SharePoint site. 

Using the address to the file results in an error and this is well documented. 

The solution is generally to connect to the site and then filter. 

However this does not work for me.  It times out or, if I manage to apply a filter to one column (say look for files modified in the last month) then I do not see the file that I want (although I know it is there).  This is really frustrating me.

Has anyone managed to do this?

[Ian_Altis]

The easiest way to do this that I know of is just to change the M Code from SharePoint.Files to SharePoint.Contents:

[mahoneypat · Accepted solution]

Please see this article and try using SharePoint.Contents instead. Imke also provided a function to get a single file faster too.

Improve File Import from SharePoint in Power BI and Power Query – (thebiccountant.com)

Pat

[Ian_Altis]

That's great @mahoneypat .  Long code but it only needs pasting 😀 Hopefully MS will build a connector based upon this!  I actually managed to get mine working using the standard connector and some lateral thinking but it wasn't easy.

[craigiouk]

What the actual hell, why cant we just navigate to the file? is that too much to ask?