cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
przemyslaw Frequent Visitor
Frequent Visitor

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

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

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

Hi @przemyslaw ,

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.

View solution in original post

2 REPLIES 2
Community Support Team
Community Support Team

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

Hi @przemyslaw ,

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.

View solution in original post

przemyslaw Frequent Visitor
Frequent Visitor

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

Privacy level was an answer, thank you.

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)
Users online (2,661)