Forum Discussion
Dataflow and Dataset treating null differently
We have a master dataset that was configured to connect to an Oracle database. Nearly 30 odd reports have been built on this dataset (which has around 20 tables - dimensions and facts) using live co...
Just hit this issue as well. It is appalling behavior, IMO, as it means that converting a PowerQuery straight to a source, to one going via a Dataflow, does not preserve behavior. In my case, rows were silently lost because I had filters on (null). Even changing to reflect the obvious impact on filter then means need to consider possible impact everywhere else. Given that PowerQuery distinguishes Nulls and Space, storing as CSVs (with no special null handling) was maybe not the best of ideas !