Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
azeem2020
Regular Visitor

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

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? 😥

5 REPLIES 5
atul06
Employee
Employee

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

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.

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

amitchandak
Super User
Super User

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

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.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.