Forum Discussion
SharePoint.Files() works but SharePoint.Contents() won't authenticate
Recently migrated hundreds of Windows shares to SharePoint Online. This forced us to modify any processes that used Power Query to read data from Windows to now read data from SharePoint. Most of the...
Hi bpearce, I use SharePoint files as a data source for several Workspaces, so I have come across the issue that you have encountered. One example open over 500 files twice. Once to read the date, and second time to read the data. In this situation, I am using SharePoint.Contents in a Dataflow backed by "EM1" capacity. Each file is read from it Binary using a Custom Function. I don't use the "Expand Table" features. The input to the custom function is the Binary file. I then use the Binary.Buffer function before the Excel.Workbook function.