Skip to main content

Power BI

New

Keep null values in text data types for dataflows

Vote (23) 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 (2)
's profile image Profile Picture

1e269a6c 84e0-ea11-a813-000d3a9b112e 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

00450b3e cdaa-4b1f-b93d-697e9efaca34 on 16 Aug 2020 04:20:21

RE: Keep null values in text data types for dataflows

Are there any temporary solution for this?