JSON file upload to PowerBI

[ArT101]

Converting a column record to a list - Resolved

[ImkeF]

Hi @ArT101 ,
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?

[ArT101]

I've resolved the issue

[ArT101 · Accepted solution]

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.