Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
Anonymous
Not applicable

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 filejson error.PNG

 

So currently the data flow is like

application insights-> Azure blob storage -> Power BI.

 

Thank you for help

1 ACCEPTED SOLUTION
Anonymous
Not applicable

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

View solution in original post

6 REPLIES 6
Anonymous
Not applicable

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

Anonymous
Not applicable

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
Community Support
Community 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 _ kalyj

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

 

Anonymous
Not applicable

Hi @v-yanjiang-msft ,

 

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

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.

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
Super User
Super User

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.

Imke Feldmann (The BIccountant)

If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!

How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors