DataFormat.Error: We found extra characters at the end of JSON input.

[azeem2020]

Source: Azure Blob Storage

Source = AzureStorage.Blobs("xxxxxxdev001")

JSON data is coming from Azure Blob Storage and JSON files are PostgreSQL Server Diagnostics Logs:

let
    Source = AzureStorage.Blobs("xxxxxxdev001"),
    #"insights-logs-postgresqllogs1" = Source{[Name="insights-logs-postgresqllogs"]}[Data]
in
    #"insights-logs-postgresqllogs1"

Error Details: 

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

When I try to navigate through Binary, getting above error - not sure why? 😥

[atul06]

@azeem2020  I m facing same issue. Is this resolved at your end ?

[azeem2020]

No, I haven't attempted it for a while, but I've been working on an alternative approach to reformat the JSON using Python and then passing the file to analyzer. Please let me know if you have any opportunities to resolve it.

[atul06]

In Power Bi Desktop its working fine for me, in service i m getting issue

[amitchandak]

@azeem2020 , this error come when the json format has some issue. some character is not required or missing position

[azeem2020]

Those JSON files are being generated automatically by enabling Diagnostic Setting on PostgreSQL - Flexible Server.
Configure and Access Logs for Azure Database for PostgreSQL - Flexible Server - JSON format 
So I assume, JSON is well formatted otherwise Microsoft should rework on their format. But here in my case - the issue is somewhere else.