We cannot convert the value "008" to type Table

[maasool]

Hi!

Can anyone suggest how to solve this problem?

I expanded column, which contained "Table"s and it generated this result at the end.

Best regards

[maasool · Accepted solution]

This helped me to solve the problem:
https://community.powerbi.com/t5/Desktop/Expand-column-containing-both-text-and-table-types/m-p/4563...

[wdx223_Daniel]

before using the function of Table.ExpandTableColumn, to make sure all the values of this column is table.

[maasool]

Hi! Thanks, I now understand the problem and your proposed solution. However, I am not sure how to implement this. Could you be more precise how should I use the function?

[maasool]

I think I managed to add this function, but now I have a new error: