Forum Discussion
Getting a single file from a large SharePoint site
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
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
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?
