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.
4 Comments
- rene_gomezNew MemberAre there any temporary solution for this?
- SonHNew Memberthis is seriously a bug and a defect in my opiniion
- JBaityNew Member
It also can't seem to keep percentage column types after saving in PBI Service.
- fbcideas_migusrNew MemberStatus added:Needs Votes
Recent ideas
Reintroduce Tenant/Capacity Switch to Control "Users can create Plan items" Post-GA
During the Preview phase of Fabric Plan items, administrators had access to a dedicated tenant/capacity setting: "Users can create Plan items". With General Availability (GA), this granular administr...Sri-Surendra_Ku1 hour agoNew MemberNew97Views13likes1CommentSupport Fabric SQL Database with workspace-level inbound Private Link
Fabric SQL Database supports tenant-level Private Link but not workspace-level Private Link. Securing a small number of databases therefore requires enabling Private Link across the entire tenant, in...WorkFull223 hours agoAdvocate INew8Views1like0CommentsImprove Relationship UI Wording to Better Reflect Filter Propagation Direction
The current relationship dialog can be confusing because the UI labels "From" and "To" do not always align with users' linguistic expectations regarding filter propagation. As per document : Relation...v-varunvv4 hours agoMicrosoft EmployeeNew14Views4likes0CommentsDynamic ADLS-Gen2 path input for Spark Jobs Main definition file
I would like the ability to add a dynamic input box on a spark job definition's "Main Definition File" "ADLS-Gen2 path". this would be useful to set base and variable paths across all spark jobs...mfink_db4 hours agoNew MemberNew224Views2likes1Comment