Forum Discussion
JSON file upload to PowerBI
The code in Advanced Editor was changed to read the data as CSV documents to combine the column data before converting to JSON. This allowed me convert the column to a list then created custom columns pulling the values from those list to create a string of values separated by a delimiter.
Hi Anonymous ,
if the color indicators are correct, the comma separates a nested record within the main list of records.
So there must be some transformations in the expansion-steps that cause the result you're seeing.
Are you able to post the M-code that has been generated?
I've resolved the issue
The code in Advanced Editor was changed to read the data as CSV documents to combine the column data before converting to JSON. This allowed me convert the column to a list then created custom columns pulling the values from those list to create a string of values separated by a delimiter.