error json input

Public Schedule Face-to-Face & Virtual Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Power BI training and help » Error in JSON input

Error in JSON input

resolvedResolved · High Priority · Version 365

Error in JSON input

Hello,

I have an issue with fetching data from customised Azure Blob Storage server.

When I upload a file to Power Query, I can see all data uploaded correctly and up to date.

After applying everything to the dashboard, whilst data loading there is an error popping up on the screen:

"Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error: [DataFormat.Error] We found extra characters at the end of JSON input.. '."


I tried to find a solution and search for a similar scenario but I am unsuccessful at the moment.

May I ask you for any suggestions?



Kind Regards,


Piotr Jedrzejczyk

RE: Error in JSON input

Hi Piotr,

Thank you for the forum question.

Unfortunately it is not a question I can answer. I have asked the other Power BI trainers in STL and any of them have experienced this error.

I have also tried to Google and I can find some links which may be can be useful to solve the issue.

https://community.powerbi.com/t5/Desktop/We-found-extra-characters-at-the-end-of-JSON-input/m-p/20607

https://community.powerbi.com/t5/Power-Query/quot-We-found-extra-characters-at-the-end-of-JSON-input-quot/td-p/1218129

https://techcommunity.microsoft.com/t5/excel/we-found-extra-characters-at-end-of-json-line/m-p/137995

Sorry I am not very helpful but I hope the links above can help you.



Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Will be marked as resolved in 5 days

Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.

 

Training courses

 

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Power BI tip:

Data Cleaning and Transformation

Ensure your data is clean and well-structured before importing it into Power BI. Use Power Query Editor to clean and transform your data. This tool allows you to perform various operations like filtering, merging, and reshaping data, ensuring it's in the right format for analysis.

View all Power BI hints and tips


Server loaded in 0.08 secs.