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.
In my case, a bad choice for lack of experience: I had a column set to Table.ExpandListColumn (my data source is a SharePoint list) what gave me some duplicate rows, a bad thing since I'm calculating hours. Just followed the first code and it worked imediately.
Thank you very much!