Error on Azure Logs on BLOB: DataFormat.Error: We found extra characters at the end of JSON input

[Anonymous]

I am saving ADF logs and metrics to a Azure BLOB to reuse it then in PowerBI to show them.

But the saved format of the automatic log files of Azure seems invalid - no matter which you choose.
Seems that the last character is invalid!?
Anyway, so any Azure Logs can not be used in PowerBI by importing from BLOB!!!

DataFormat.Error: We found extra characters at the end of JSON input.
Details:
Value={
Position=326

[Anonymous]

Hi @Anonymous,

Have you succeeded work with this data source before?
If you test with no succeeds, I'd like to suggest you to export the source data as text and paste to json verified tools(you can google it) to confirm if they are common json data or something stored as json format. (the second scenario will store data as JSON lines but not refer to the rule of JSON. they may miss the start or end characters '{','}' or delimiters in the records)

In addition, you can also take a look at following thread that discussed similar issues:

We found extra characters at the end of JSON input. 

Regards,

Xiaoxin Sheng

[Anonymous]

These are json files produced by Azure Log Analytics - so I can not change them, I just want to use them...
So
option 1: Azure produces valid json files
option 2: PowerBI can handle this json

[Anonymous]

Hi @Anonymous,

I checked the known issue lists but not found any similar scenario. Did this issue only appear on your account? Have you test with other credentials to get data?
BTW, I think this should more relate to azure side, you can consider contacting azure support to confirm if any backend verifies related issues.

Regards,

Xiaoxin Sheng

[Anonymous]

Hi!

For me that is a no-go to communicate in Spanish here...
Oliver