Forum Discussion
luukjedlix
1 year agoNew Member
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...
- Anonymous1 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.
- 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.\
- If you’re able to see the JSON, kindly check if it is valid.\
- 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)
- 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.
Anonymous
1 year agoNot applicable
Hi luukjedlix ,
Has the issue been resolved on your end? If so, please share your solution and mark it as "Accept as Solution." This will assist others in the community who are dealing with similar problems and help them find a solution more quickly.
Thank you.