Forum Discussion

prathyoo's avatar
prathyoo
Advocate II
5 years ago

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...
Need Help
prathyoo's avatar
prathyoo
Advocate II
5 years ago

Here are the screenshots -

 

Original DB Connected dataset - the literal "(null)" in the power query was replaced as "(Blank)" in the tabular model -

 

And here is the dataset that connects to the dataflow - the literal "(blank)" in the power query has been replaced by an empty string.

 

 

    • prathyoo's avatar
      prathyoo
      Advocate II
      5 years ago

      Greg_Deckler   Thanks for taking notice of this issue. Would you be able to help us out. We have separately raised this with support and are waiting to see how that proceeds.

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        Hi, did you receive any reply from support on this behaviour?

    • strongCoreZach's avatar
      strongCoreZach
      Advocate III
      2 years ago

      This is apparently still the case. Had a client that processed the same spreadsheet in dataflows vs desktop, with the same Mcode. Service processed as blanks, desktop returned null. To mirror the table in both, he had to processs for both null and blanks.