data export from azure blob to power bi json file error

[rpatil]

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

[rpatil · Accepted solution]

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

[rpatil]

Thank you for replyig but if i import data directly from application inisghts to power bi it is not showing error. do you think maybe azure storage is causing the problem?

[v-yanjiang-msft]

Hi @rpatil ,

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.

[rpatil]

Hi @v-yanjiang-msft ,

I saw this but it doesnt have solution, thank you for replying very much

[v-yanjiang-msft]

Hi @rpatil ,

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.

DataFormat.Error: We found extra characters at the end of JSON input. Details: Value= Position=0 | P...

"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 _ kalyj

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

[ImkeF]

Hi @rpatil ,
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.