Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Unexpected end of input was found in JSON content

I am trying to refresh a dataset which retrieving data via an api from DY365. But everytime it gives below error in middle of a powerQuery step.   "Datasource. Error: ODATA: Invalid Json. Unex...
  • Jimmy801's avatar
    5 years ago

    Hello Anonymous 

     

    this means a Json-file is corrupted. Maybe created by a interface. What you could do if one character is missing at the end and in case put it... so basically reading the binary from json, adding the missing character if missing and then reread it.


    If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
    Kudoes are nice too

    Have fun

    Jimmy

  • Jimmy801's avatar
    Jimmy801
    5 years ago

    Hello Anonymous 

     

    I think the error is not even caused by this query but the error is caused by the query you are merging with. So the error appears when the merged query is queried. But still.... the problem is probably a corrupted json-file.

     

    If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
    Kudoes are nice too

    Have fun

    Jimmy