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 ,
As we have not received a response from you yet, I would like to confirm whether you have successfully resolved the issue or if you require further assistance. If the issue has been resolved, please mark the helpful reply as a "solution" to indicate that the question has been answered and to assist others in the community.
Thank you for your cooperation. Have a great day.