Forum Discussion
DataFormat.Error when using Table.ExpandListColumn()
Do following -
At the bottom, you see this kind of message
Click the message starting with Column profiling and change it to "Column profiling based on entire data set".
Now, check the column quality for this column and you should notice error.
To know what this error is, select the column - Home menu - Keep rows - Keep errors
You will find the rows with errors. Then you can click error and see error message and correct it.
Note - Since, you are using language other than English, you will need to translate it appropriately.
Hi,
unfortunately I cant find this message anywhere. I just get the error message. No error report or anything else indicating which coulumn is causing the problem. Looking on the column quality power query its showing nowhere an error.
Since you are expanding SalesPeriod column, hence error message you should get in that column. But before that make sure column profiling based on entire data set is set.
When I change the setting to "column profiling on entire data set" i get an unexpected error 😓
Click on one of the errors and post the message text (not picture so that I can use Google translate).