I had performance issue on my model, I'm connected to sharepoint online list with 15+ folders, 15+ files in each of them and some ~30 additional flat files. My whole model is about 700mb on Desktop. I started to have performance issues (online scheduled refresh on services was taking 4-5 hours). I found proposed solution somewhere to create one query referencing sharepoint list, and then switch source on all other queries to this single query, adding table.buffer ( Source = Table.Buffer(SourceQuery)).
On Desktop everything is working properly, I noticed significant performance improvement, being able to refresh data within 1h.
On services though, refresh is not working, returning error:
Data source error:
We cannot convert the value "[Binary]" to type Binary.. The exception was raised by the IDbCommand interface.
I'm sitting on Premium workspace with Pro license, as it's connected only to sharepoint, gateway is not being setup.