JSON File: reached end of buffer

[Sibrulotte]

Hi, 

I have a JSON file retrieved from a POST call in Postman. This JSON file was parsed successfully once in my main file, and I was a happy camper.

Unfortunatly, the next day, I refreshed the POST call in Postman, saved the response to my JSON file again overwriting it. The minute I tried to refresh the query using that file there was an errror message: We reached the end of the buffer ...

I tried openeing the file from another Power Bi document, fresh, with all windows around closed, and alas, same message.

What would be the issue you think?

[parry2k]

@Sibrulotte glad to hear you found the solution and thanks for sharing it here. I'm sure it will be helpful to others. This is what makes this community great. Cheers!!

Check my latest blog post Compare Budgeted Scenarios vs. Actuals I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[parry2k]

@Sibrulotte not sure why you get this buffer error, can you share a sample pbix file? What kind of transformation are you doing if any? Do you happen to know how many records are in the file?

[Sibrulotte · Accepted solution]

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.

Thank your for your time.

[v-robertq-msft]

Hi, @Sibrulotte 

Thanks for your experience sharing. If you have solved your problem by yourself, would you like to mark your own reply as a solution so that others can learn from it too?

Thanks in advance!

How to Get Your Question Answered Quickly 

Best Regards,

Community Support Team _Robert Qin

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

[PhilipTreacy]

Hi @Sibrulotte 

For what it's worth, is the reponse incomplete because the request was invalid or was the request valid but the returned data was badly formatted or truncated JSON?

If a request is invalid and the expected returned data should be JSON, then what happens is you actually get a HTTP response back (which isn't JSON) and any attempt to parse JSON fails.

It's always best to check what response is actually received rather than assume you get what you asked for.

I know you said that your first request worked, so it would look like your request is properly formed. However you can still get an error returned if there's a problem with the service you are connecing to (perhaps a 404 Not Found or a 500 Internal Server Error).

Anyway, just thought that might be useful to bear in mind for the future.

regards

Phil

[Sibrulotte]

Thanks Phil, the response starts off well, but is just truncated and doesn't end with a JSON synthax closure.

So I need to fix that POST call before I do anything else. 🙂

[Sibrulotte]

This forum goes so fast, almost third page within an hour... 

[Sibrulotte]

I see 6K to 14k users.

@amitchandak @parry2k @PhilipTreacy @mahoneypat  @MFelix 

You guys seem to be the all star.

Is my question far fetched or impossible to adress?

Should I just figure out a way to make the REST API connector work? cause that was a deadend rather quickly too for me.

[Sibrulotte]

you for the support. 

The file currently is 1.1M in size, and has all the data I need with the same parsing format that the initial file had.

[nvprasad]

Hi,

Kindly check the json file might have no records ( Blank file).

Appreciate a Kudos! 🙂
If this helps and resolves the issue, please mark it as a Solution! 🙂

Regards,
N V Durga Prasad