Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Extracting data from blob and getting errors in table , please suggest

Dear experts   I am extracting data from azure blob, but some of the table we are getting errors as below    An error occurred in the ‘Transform File (3)’ query. DataFormat.Error: We found extra ...
Need Help
Show and Tell
Anonymous's avatar
Anonymous
Not applicable
2 years ago

After performing the invoke 

,
#"Invoke Custom Function1" = Table.AddColumn(#"Filtered Hidden Files1", "Transform File (2)", each #"Transform File (2)"([Content]))

 

An error occurred in the ‘Transform File (2)’ query. DataFormat.Error: We found extra characters at the end of the JSON input.
Details:
Value={
Position=2118

 

 

Please suggest how to get rid this character issue 

 

Thank you

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Anonymous - as checked in azure blob we are getting the json files in location some with one record and some json files we have multiple records as below:

     

    One records in one json

     

    Multiple records in one json files:

     

    Please suggest

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hi Anonymous ,

       

      Thank you for your additional information.

       

      Please try to wrap multiple Json objects in an array by adding [ at the beginning of the first line, ] at the end of the last line, and , between each line to compare the results.

       

      Best regards,

      Joyce

      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.