Forum Discussion
Dataflow Column Data Mismatch in Power BI Desktop
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,
my guess is there is some confusion/assumption around "" and null . General guidance is to avoid the usage of "" in favor of null.
