Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
We have created a linked entity in the dataflow; however, in the linked entity, all the null values (i.e. null) in the text fields have been automatically transformed into empty (""). We didn't notice this transformation for fields with other data types.
Further testing shows that the dataflow automatically treats null text values as empty.
See below example:
Example 1: Power BI dataflow autom-detects null text values as empty
Example 2: Original dataflow vs linked entity
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @HShi,
From the first screenshot from you, we can see that Power BI treats these values as Generic data type but not Text data type when retrieving data from the original dataflow. The data types from the original are not kept in the downstream dataflow. If you change its data type to Date munually, you shoud see the empty rows displayed as null values again.
Best Regards,
Community Support Team _ Caiyun