Forum Discussion
Null Values in Data Suddenly
They match... I am so stumped!
Hi nmcquaid ,
You've already done a lot of the right checks, so let’s try to dig a bit deeper. Please try to check the below:
Even if the headers “look” the same, sometimes extra spaces, non-breaking spaces, or other invisible characters sneak into headers (especially if the data source process changed slightly).
-
Open one of the newer CSVs in a text editor (like Notepad++) and compare the header line character-by-character with one from before 2/25/2025.
-
Alternatively, in Power Query, use the Table.ColumnNames(Source) to inspect the actual column names from both old and new files to catch any discrepancies.
If I misunderstand your needs or you still have problems on it, please feel free to let us know.
Best Regards,
Menaka
Community Support Team
Hi nmcquaid ,
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.
Hi nmcquaid ,
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.