expanding column with record and list

[tijuemson]

Hi All,

i am stuck in a problem following is a column i have i cant expand it because it has List and Record in it.

list is the combination of a lot of records and i tried converting everything to list and then expand it..it didnt work.

following is the mquery

let
Source = DocumentDB.Contents"Source"),
Expanded1 = Table.ExpandRecordColumn(Source, "Document", {"id", "details"}, {"Document.id", "details"}),
Expanded2 = Table.ExpandRecordColumn(Expanded2, "expanded 1", {"detail"}, {"detail"})
in
Expanded2

any help is appreciated.

i saw another post regarding this but for that the list was empty for me list and record has records

[v-deddai1-msft · Accepted solution]

Hi @tijuemson ,

Here is a good post for your reference: https://stackoverflow.com/questions/33928781/transforming-json-with-power-query-mix-of-list-and-reco...

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai

[selimovd]

Hello @tijuemson ,

I also don't know the answer, but maybe you should post that in the Power Query Forum and not in Power BI Desktop.

The chances that the Power Query Pros can help you with this is a lot higher.

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards
Denis

Blog: WhatTheFact.bi