The option to open the list in the power query is not appearing. What can I do?

[andreiamrlira]

Hello guys. When a column is formed by lists, the option to open and transform into rows by placing the comma separator is not showing up for me. I don't know what's going on '-' Can anyone tell if they've had this problem too and what they did to solve it? In the selected column "principais_bandeiras_do_mandato_campan". Thanks!

I think it's important to mention that this data is coming from an integration with pipefy. We're using an external connector to do this kind of information sharing.

Note: the fact of being filtered does not interfere. I just did this to show in the photo how the list appears in the column.

[AntrikshSharma · Accepted solution]

@andreiamrlira Your column contains a scalar value, for Table.ExpandListColumn all the values should be list or null.