In Power Query, I encountered an issue where I had a column formatted as Whole Number. There were Null values in the column, so I added a step to replace Null with zero. After that step, somehow Powe...
Hi rwmed99a
Here is my PQ . After I replaced the null value with 0 , I did have the problem you mentioned, the data type was automatically changed, then I changed it back to whole number, and I was successful. Can you create a simple samplet and provide it to us for testing?
Best Regards,
Community Support Team _ Ailsa Tao