"DataFormat.Error: We reached the end of the buffer."

[JeffGrant]

Hi All,

Periodically, I receive this error message. I am not sure, if this a Power Query error or a VBA error?

I do suspect that it is PQ error when downloading Json data from a server because it generally happens when I am refreshing a table a PQ table.

To solve the issue, I generally wait 15 minutes, reboot the PC and off we go.

Rather than haulting the operation of the model, is there a way I can trap this error, have the model wait 10 minutes and the try the refresh again, with out my intervention?

Thanks in advance.

 

[bobsan42]

See if this may help.

 

[JeffGrant]

Thanks mate. I haven't checke din for a while. Sorry about the late reply.