How can I display all data attributes, including lists, on one line in Power Query?

[Leo_kaile]

Hello

I currently have the problem that I cannot display my data completely on one line, because in the last column there is a list element with values, so far I have only managed to display 4 lines at the end. My goal is that each value in this list gets a column, but so far I have not figured out how to do that. Can anyone help me?

Hello

The data comes from an API endpoint, and unfortunately the structure of the latest API version is structured in such a way that self-created attributes are displayed in lists that are nested multiple times

I would be very happy if someone could help me further

Best regards

[ManuelBolz · Accepted solution]

Hello @Leo_kaile ,

Maybe this solution will help you:
https://community.fabric.microsoft.com/t5/Desktop/Extracting-a-list-of-key-value-pairs-into-multiple...

Best regards from Germany
Manuel Bolz

🟦Follow me on LinkedIn
🟨How to Get Your Question Answered Quickly
🟩Fabric Community Conference
🟪My Solutions on Github