Forum Discussion
Online refresh fails after adding Table.Buffer,, Desktop refresh work properly
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
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.
2 Replies
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.