Table.ExpandTableColumn returning null values

[Anonymous]

I've joined these...

When hovering over the 'tblRWtømningsdag' field, I get the following values:

However, when expanding 2 of the columns, I get null values returned:

What could explain this behaviour - and what's the fix?

This is Excel PowerQuery by the way.

Thanks in advance for any help.

[Anonymous · Accepted solution]

It'd seem like the issue was related to lowercase/uppercase values. 

There was an actual in uppercase/lowercase between the 2 joined tables, and still Power Query Editor showed me the table data in the preview (surely an error?) but nothing when expanding (as expected).

Transforming the values in the joined column in both tables to uppercase before joining helped.

[Payeras_BI]

Hi @Anonymous ,

Difficult to tell without having a sample file to reproduce the issue but check the use of Table.Buffer function and see if would be of any help in this specific scenario.

Regards,