98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Power BI training and help » Error in JSON input
Error in JSON input
Resolved · High Priority · Version 365
Thu 1 Sep 2022, 11:53Delegate Piotr said...
Piotr has attended:
Power BI Modelling, Visualisation and Publishing course
Power BI Modelling, Visualisation and Publishing course
Power BI Modelling, Visualisation and Publishing course
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
Mon 5 Sep 2022, 13:02Trainer Jens said...
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
Fri 12 Jan 2024, 00:35Trainer Rich said...
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.
|
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
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Power BI tip:Data Cleaning and TransformationEnsure 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. |
