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
About "Download SQL database project" and fix the downloaded project
1. The sqlproj must be fixed, it is downloaded without the xml markup line <?xml version="1.0" encoding="utf-8"> 2. The sdk must be updated: Actual: <Sdk Name="Microsoft.Build.Sql" Version="0.1...Jarrinf4 hours agoFrequent VisitorNew48Views3likes2CommentsEventstream MQTT broker source: V3.1.1 support
The Eventstream MQTT broker source supports connections with public MQTT brokers that offer MQTT V5 support. Please offer support for V3.1.1 too, because this is still a valid and widely used ver...svelde5 hours agoSuper UserCompleted1.4KViews6likes4CommentsGet data from Apache Kafka topics via private networking
Current prerequisites limit to public Kafka instances which is not feasible for most enterprise customers. When will this limitation be lifted so that it can be used in private network setups, for ...Jugi5 hours agoMicrosoft EmployeePlanned3.5KViews2likes3CommentsSet default x axis scrolling position
Enable selection of the default scroll position for the x-axis on a chart. For example, on a line chart with dates as the x-axis, when not all of the data can display in the view at once, the scroll...Lisa_Krieg13 hours agoNew MemberNeeds Votes7.8KViews1154likes104Comments