Power BI Dataflow with column type text having null value is rendered as blank in dataset

[Anonymous]

I have observed one thhing about Power BI dataflows. Entity having column as datatype Text while has null values in it. When i Get Data from that Dataflow  in Power BI desktop that column value is rendered as blank in dataset. 

I have noticed its for coulm with datatypoe text It works well for Number value.

Can someone please advise if this is an issue with dataflows

[ivan_larson_cki]

@daanhumble Thanks! That query step is very helpful rather than having to call out individual columns.

I'd still like to see a workaround on the Dataflows side, but this is a useful stopgap.