DataFormat.Error: We reached the end of the buffer error from Power BI + Source Data from Azure Blob

[Anonymous]

I am using Power Source as Azure Blob Storage folder. While connecting the JSON file from Azure Blob Storage facing an error "DataFormat.Error: We reached the end of the buffer".

[v-xicai]

Hi @Anonymous , 

You may try to upgrade the Power BI Desktop to the latest version 2.82.5858.961 , and maybe the 64-bit Desktop will overcome this issue.

Reference:

https://community.powerbi.com/t5/Desktop/DataFormat-Error-We-reached-the-end-of-the-buffer/td-p/451367

https://community.powerbi.com/t5/Desktop/Error-oledb-or-odbc-error-data-format-We-reached-the-end-of-the/td-p/514604

Best Regards,

Amy 

Community Support Team _ Amy

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

[Anonymous]

Hi Amy,

Thanks for sharing your solution. 

However, I tried below steps before rasing this issue. 

- Yes, I installed latest desktop version (Jun-2020), but still no luck. 

- Also used Table.Buffer in M-Code, but still no luck. 

Regards, 

Muthu

[v-xicai]

Hi @Anonymous ,

If you still have this issue for Power BI, you'd better create a support ticket in Power BI Support , Scroll down and click "CREATE SUPPORT TICKET", or go to Issue forum  to get further help.

Best Regards,

Amy 

Community Support Team _ Amy

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

[nvprasad]

Hi,

Can you check whether JSON file has any data? Usually, we get this error when you trying to import a blank JSON file.

Regards,

Venkata Nalla

[Anonymous]

Hi Venkata Nalla, 

It gives 0 Bytes for the JSON file which I used. But in AZURE BLOB it shows 27 MB. Where the data is missing in my case. 

Regards,

Muthukumar