Skip to main content

Power BI

Needs Votes

Keep null values in text data types for dataflows

Vote (41) Share
's profile image

on 25 Jan 2019 15:48:47

When pulling null values from a text data types in a dataflow it currently pull blank text string rather than a null. This is meaning a transform is then required in the dataset to transform it back to a null. This creates a few issues, 1) if the data requires a differentiation between a null and a blank it is impossible to get this value back (unless a secondary column to indicate the nulls) 2) means that an analyst needs to remember to transform the column in the every dataset it is used 3) if a dax formula is used to count the nulls for a calculation this won't report correctly unless the analyst remembers to do the transform.

Comments (3)
's profile image Profile Picture

J B on 21 Mar 2023 16:32:19

RE: Keep null values in text data types for dataflows

It also can't seem to keep percentage column types after saving in PBI Service.

's profile image Profile Picture

Hans Son on 03 Sep 2020 15:13:22

RE: Keep null values in text data types for dataflows

this is seriously a bug and a defect in my opiniion

's profile image Profile Picture

René Gómez on 16 Aug 2020 04:20:21

RE: Keep null values in text data types for dataflows

Are there any temporary solution for this?