Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi Experts,
I am extracting data from azure blob we are getting the json files format in location some json we have one record and some json files we have multiple records in each json as below:
One records in one json
Multiple records in one json files:
Is due to that after invoke function, in transform file, getting table (single record) , errors are coming having multiple records.
#"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
Checked in json viewer invalid due to multiple records. i was stuck is there any possible to bring the error record ?
Please suggest
Solved! Go to Solution.
Hi @Anonymous
Please try adding “[”at the beginning, “]”at the end, and “,” after every line.
Here is my test result, checked in Json Viewer is valid.
Here are similar cases for your reference:
Solved: We found extra characters at the end of the JSON i... - Microsoft Fabric Community
We Found Extra Characters at End of JSON Line - Microsoft Community Hub
Best Regards,
Jarvis Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous
Please try adding “[”at the beginning, “]”at the end, and “,” after every line.
Here is my test result, checked in Json Viewer is valid.
Here are similar cases for your reference:
Solved: We found extra characters at the end of the JSON i... - Microsoft Fabric Community
We Found Extra Characters at End of JSON Line - Microsoft Community Hub
Best Regards,
Jarvis Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
114 | |
95 | |
90 | |
35 | |
35 |
User | Count |
---|---|
154 | |
102 | |
82 | |
64 | |
54 |