Forum Discussion
Date column all null
I am trying to load a spreadsheet into power query but the entire date column labeled "Accounting Date" is returning null. I looked through the applied changes and removed the automatic ones that wou...
Hi Cmclaughlin2 ,
Thanks for all the replies!
And Cmclaughlin2 , Can you check if the column was already null in the Source step or did it become null in a later step?
If the Source is already null at this step, it may be a connector problem, so I recommend you to clear the cache of Power Query and try to connect again. If the subsequent steps are null, then we need to check your detailed transformation steps to find out why.
Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.