error due to an empty file when importing the data

[TheBigLo]

I'm using a json from a webservice with parameters (to speed up acquisition) as the data source.

these parameters are dynamic.

 This can have the effect of returning an empty file to me, which gives me the following error.

DataFormat.Error: <pii>We reached the end of the buffer.</pii>. . The exception was raised by the IDbCommand interface.

Is it possible to prevent this error in case of empty file?

[v-yiruan-msft]

Hi  @TheBigLo,

The following ones are the threads which has the similar problem as yours, please check their solutions. Hope they also can help you solve the problem.

JSON File: reached end of buffer

---

Well I have been able to locate the problem:

The POST call returns an incomplete response thus incomplete JSON file is saved. 

It seems to be an issue with my data provider.

So moral of the story is: incorrect JSON format will give an end of buffer memory error.

Pivot Column results in DataFormat.Error: We reached the end of the buffer...

Try the following: uncheck "Allow data preview to download in nthe backgroup" and "Enable parallel loading of tables" and check if this issue persists or not.

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

1. Try reinstall desktop, which has worked for someone who had the same issue.

2. Try change max cache size in the option. It looks a memory issue.

DataFormat.Error: We reached the end of the buffer

Refresh fails with error We reached the end of the buffer.

If the above ones can't help you, could you please provide the setting of your dynamic paramters? And which one will be with empty value? Thank you.

Creating Dynamic Parameters in Power Query

Best Regards