Forum Discussion
data export from azure blob to power bi json file error
- Anonymous3 years ago
Hi all,
Thank you for the replies, i was able to find the solution. I just tried filtering out first few days of export from application inisght to azure storage. Then when i exported data from azure storage to PowerBI, Power query was ableto identify json file properly. I dont know the exact cause why this worked. No changes were made to source system of json files or anything. Maybe this was export problem from application inisghts to azure storage.
Thank you all for the help
Hi Anonymous ,
This issue has been discussed many times, refer to the solutions in the below thread.
We found extra characters at the end of JSON input... - Microsoft Power BI Community
Best Regards,
Community Support Team _ kalyj
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- v-yanjiang-msft3 years ago
Community Support
Hi Anonymous ,
You can use the JSON Formatter to verify if the JSON is valid. Some solutions said that the URL in your query responds with HTML not JSON, I think the explaination in the below threads may help you.
"We found extra characters at the end of JSON input" error. | MrExcel Message Board
JSON format error · Issue #7 · stansw/vsts-open-in-powerbi · GitHub
We Found Extra Characters at End of JSON Line - Microsoft Community Hub
Best Regards,
Community Support Team _ kalyjIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.