Zero value data is replaced by null and no difference of voids or zero

[Syndicate_Admin]

Hello everyone!

I have a problem with a load of data from an excel file, in which there are columns of decimal values, the decimal data there is no problem, but some of them the value is 0 and others is empty, when importing the data from excel to power query the values 0 appear as null and I can not differentiate them from the voids that are also incorporated as null. How can I make when importing the values that are 0 appear as zero and the voids as null?

Thanks for your help!

[v-yadongf-msft]

Hi @Syndicate_Admin ,

Unfortunately, I can't reproduce the scenario you described.

Is it still the same after changing the data type?

Best regards,

Yadong Fang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.