Power BI Desktop getting Json error when loading data

Hi OCW-APM ,

Based on the error message you've provided, it seems like Power BI is encountering unexpected characters in your JSON input, specifically beyond what it considers the end of the JSON data. This type of error often occurs due to formatting issues within the JSON file itself, such as trailing commas, unescaped characters, or additional text after the JSON object closure.
To this I can only offer you some possible suggestions, for example:
Use a JSON validator tool to check if your JSON file is correctly formatted. This can help identify any syntax errors that might be causing the issue.
Look at the position indicated in the error message (Position=4). There might be unexpected characters or syntax issues near this location.
Try loading a very simple JSON file to see if the issue persists. If the simple file works, the problem is likely related to the specific content or structure of your original JSON file.

In addition I found some links where the same question as yours appears. Perhaps you can find the answer in those links:
Excel - We found extra characters at the end of JSON input - Stack Overflow
Solved: Data Format .Error: We found extra characters at t... - Microsoft Fabric Community
Solved: JSON Parsing Issue - Power Platform Community (microsoft.com)

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