Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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
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
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
Hi!
For me that is a no-go to communicate in Spanish here...
Oliver
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
76 | |
74 | |
49 |
User | Count |
---|---|
145 | |
108 | |
107 | |
89 | |
61 |