Solved: Re: JSON file upload to PowerBI

Anonymous · ‎11-02-2022

Converting a column record to a list - Resolved

Anonymous · ‎11-03-2022

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.

View solution in original post

ImkeF · ‎11-03-2022

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?

Imke Feldmann (The BIccountant)

If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!

How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries

Anonymous · ‎11-03-2022

I've resolved the issue

Anonymous · ‎11-03-2022

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.