Forum Discussion

luukjedlix's avatar
luukjedlix
New Member
1 year ago
Solved

Json error while refreshing semantic model

Hi guys,   I'm getting the following (not very descriptive) error while refreshing my semantic model in fabric PBI: Data source error: We found an unexpected character in the JSON input.. The exc...
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi luukjedlix ,
    Thank you for reaching out to us!

    You may check this by going into Power Query Editor and looking at the source step for that table.

    1. Try copying the URL used in the query and pasting it into a browser or a tool like Postman. If the response doesn’t look like structured JSON , that is might causing the issue.\
    2. If you’re able to see the JSON, kindly check if it is valid.\
    3. Even if you haven’t changed anything recently, the web source itself might have. For example, the data format could have changed, the source might now require a login or different authentication, or the URL could be redirecting or returning an error message instead of the expected data. One way to handle this is by adding error-handling in Power Query using a try...otherwise statement(for example: try Json.Document(Web.Contents("https://...")) otherwise null)
    4. If you're using a data gateway for refreshes, double-check that it’s running and up to date.

    Hope this resolve your query.If so,consider accepting it as solution.

    Regards,
    Pallavi.