JSON Multiple Records Create Lots of Columns

[olegkazanskyi]

As a JSON file, I have a list of multiple records.

When I try to expand the records, I get the data as a bunch of columns that suppose to be rows.

I don't want to transpose the table after the expanding step because records can change, and it will break the script.

Thank you!

[Anonymous]

Hi @olegkazanskyi ,

I'm not sure what your expected output is.

1. Please try unpivoting all columns and sorting by column names.

2. Or please take a look at past solutions.

Solved: Expanding JSON Record as Row - Microsoft Power BI Community

If I misunderstand your needs, please feel free to contact us. It is best to attach Json's format and expected output. Thank you.

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum