Online refresh fails after adding Table.Buffer,, Desktop refresh work properly

[Anonymous]

Hi

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.

Any idea what issue can be?

Regards

[v-xuding-msft · Accepted solution]

Hi @Anonymous ,

Please check whether the data type in Power Query is binary. And make sure that the privacy level for both data sources is compatible (Public/Public or Organizational/Organizational).

Best Regards,

Xue

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Privacy level was an answer, thank you.