Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us at FabCon Vienna from September 15-18, 2025, for the ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM. Get registered

Keep null values in text data types for dataflows

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.
Status: Needs Votes
Comments
rene_gomez
New Member
Are there any temporary solution for this?
SonH
New Member
this is seriously a bug and a defect in my opiniion
JBaity
New Member

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

fbcideas_migusr
New Member
Status changed to: Needs Votes