Forum Discussion
expanding column with record and list
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
Hi tijuemson ,
Here is a good post for your reference: https://stackoverflow.com/questions/33928781/transforming-json-with-power-query-mix-of-list-and-record-in-a-single-column#comment55618976_33928781
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
2 Replies
- selimovd
Most Valuable Professional
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 - v-deddai1-msft
Community Support
Hi tijuemson ,
Here is a good post for your reference: https://stackoverflow.com/questions/33928781/transforming-json-with-power-query-mix-of-list-and-record-in-a-single-column#comment55618976_33928781
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