Forum Discussion
PowerQuery and Expand Table Columns as Lists
Hi, I'm Transforming Data in PowerBI that I'm getting from a SharePoint list. Here's the rub: Some of the coIumns in the PowerBI Transform Data operation contain tables, and inside those tables...
Hi Anonymous,
Instead of expanding the list column, let's transform it's content.
Table.TransformColumns( PrevStepNameHere,
{
{ "ColumnName", each Text.Combine( _, ", "), type text }
}
)
This is assuming your list values are all of a text type.
When that's not the case or you can't be sure, include list transform, like below
Table.TransformColumns( PrevStepNameHere,
{
{ "ColumnName", each Text.Combine( List.Tansform( _, Text.From ), ", "), type text }
}
)
I hope this is helpful.
I'll see what I can do with that and reply back. Thanks.