Forum Discussion
Expression.Error: We cannot convert a value of type Table to type List.
Thanks Pete. Appear to have solved the issue. It was due to the data in People columns being pulled in as nested tables. Have added a couple of steps to expand the nested tables into seperate cokumns and it seems to have done the trick, can now see the data as needed in the report.
Thanks again for looking into this one.
Hi TomD90 ,
It doesn't look as though the step you've referenced is structured correctly.
Per MS Learn:
Table.TransformColumns(
table as table,
transformOperations as list,
optional defaultTransformation as nullable function,
optional missingField as nullable number
) as table
The first argument should reference the previous step name that represents the table you want to perform that transformation on - you're referencing the Navigation step which I can't imagine is what you're intending.
The second argument should be a list of lists that each contain the column and function that you want the Table.TransformColumns function to perform on each value - you're referencing the previous step name.
From what I can see, it looks like you're trying to null out all values in a column. I would suggest your step should look more along these lines:
= Table.TransformColumns(
UserMultiChanges,
{ {"ColumnName", each null} },
MissingField.UseNull
)
Pete