Dataflow Column Data Mismatch in Power BI Desktop

[gdps_vc]

Gretting everyone!

I have a base structured in a dataflow, but when I import this base into Power BI Desktop, a specific column comes up with the wrong data (looking at the power query of the dataflow, it is correct).

Basically, I have a conditional column with the following formula:

"PCD_Sem_Detalhes", each if [PCD] = "" then "" else "X"

The formula works perfectly in the dataflow...

However, when I import the table to the desktop, the column comes up with all the data filled with “X”.

If I create the column with the same formula in Power BI Desktop, it works normally.

Any idea why this is happening?

Best regards,

[lbendlin · Accepted solution]

my guess is there is some confusion/assumption around "" and null .  General guidance is to avoid the usage of ""  in favor of null.

[gdps_vc]

tnks for the guidance @lbendlin 

Before create the column I replaced all "" for null. And now it works.