Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Ian_Altis
Advocate III
Advocate III

Getting a single file from a large SharePoint site

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?

1 ACCEPTED SOLUTION
mahoneypat
Microsoft Employee
Microsoft Employee

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





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


View solution in original post

4 REPLIES 4
Ian_Altis
Advocate III
Advocate III

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

Ian_Altis_0-1738665146453.png

Ian_Altis_1-1738665329060.png

 

mahoneypat
Microsoft Employee
Microsoft Employee

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





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


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.

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

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Top Solution Authors
Top Kudoed Authors