Forum Discussion
Ian_Stuart_Rupe
Advocate III
Advocate IIIGetting 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 docum...
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_Stuart_RupeAdvocate III
Advocate IIIThe easiest way to do this that I know of is just to change the M Code from SharePoint.Files to SharePoint.Contents: