Forum Discussion
DataFormat.Error: We reached the end of the buffer.
Hi, So I am puzzled by this problem, and I am now at my wits' end. I have a PBI Desktop report with tables from an on-prem SQL Server and an Azure SQL database using import. I tried to add tw...
Hi,
So, apparently just waiting and trying again the day after solved the problem. A bit frustrating since I used a couple of hours trying to troubleshoot.
Anyways, now it's working!
I was able to isolate this issue to the line that extracts json.
If Json.Document get 0 bytes, it throws the "DataFormat.Error: We reached the end of the buffer".
To test this:
let
Source = Json.Document("") //will throw DataFormat.Error: We reached the end of the buffer
in
Source
SofBL
Advocate II
Advocate IIthis is exactly what happened to me when I tried to import multiple json files where one of these was empty. Its maby to quick but I solved it by adding an extra step by removing errors before expanding the json as a table