question

AntoReniHuxleyAntokinsley-0522 avatar image
0 Votes"
AntoReniHuxleyAntokinsley-0522 asked DSPatrick answered

Expand list to separate column in Power Bi query editor

I need to expand the list (Guid no:6) in the below picture which consists of 2 values in Power bi power query Editor
146865-image.png


![146873-image.png][2]


Data inside the list:
[2]: /answers/storage/attachments/146873-image.png

Is there any way to expand the list of 2 values into 2 separate rows with the same key value?
For Eg:
Input:
1->A
2->[B,C]

Expected Output:
1->A
2->B
2->C

power-query-not-supported
image.png (16.7 KiB)
image.png (2.6 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

DSPatrick avatar image
0 Votes"
DSPatrick answered

Power Bi is not currently supported here on Q&A. The product group for Power Bi actively monitors questions over at
https://community.powerbi.com/

--please don't forget to upvote and 145510-image.png if the reply is helpful--



5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.