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
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.
