Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe 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.
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?
Solved! Go to 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
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
The easiest way to do this that I know of is just to change the M Code from SharePoint.Files to SharePoint.Contents:
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
To learn more about Power BI, follow me on Twitter or subscribe 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?