Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.