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