Null Values in Data Suddenly

[nmcquaid]

Hello!

I have a PowerBI report that has existed for probably 4 years. It has been unchanged since late 2024. Suddenly after 2/25/2025, the "units produced" and "units expected" columns are returning NULL for this data. 

What I am struggling to understand is that if I go into the Azure Blob Storage and export the csv for the 25th and any time after, the data is there. But when I am transforming the data in PowerBI the same way I always have, those values come up null.

I have opened a new PowerBI session and connected to the data and receive the same result, so it is not a template issue. I have also uninstalled PBI, reinstalled and tried a different laptop as well to ensure it wasn't an install based issue. 

Can anyone help give me some ideas on where to go next? Any guidance would be appreciated.

[DineshYadl]

Hi @nmcquaid 

Could you please check the column names and data types of CSV file  in Azure Blob storage and in Power Query. 

Thanks

[nmcquaid]

They match... I am so stumped!

[v-menakakota]

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  

[v-menakakota]

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. 

[v-menakakota]

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.

[PijushRoy]

Hi @nmcquaid 

This may happen due to datatype.
In the Power Query step, please check the data if there in the Source steps
After changing the datatype, it may be not match with datatype

[nmcquaid]

Thank you @PijushRoy , tried this out and still no change.