Forum Discussion
data export from azure blob to power bi json file error
Hi,
I am trying to export data from azure blob to power bi. I am getting error related to json file
So currently the data flow is like
application insights-> Azure blob storage -> Power BI.
Thank you for help
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
6 Replies
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
- ImkeF
Community Champion
Hi Anonymous ,
this means that the json received isn't valid.
I'd suggest to copy it and analyze it with json checker that you'll find on the interwebs. 
v-yanjiang-msftCommunity Support
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 _ kalyjIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- v-yanjiang-msft
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.
