Forum Discussion

nmcquaid's avatar
nmcquaid
New Member
1 year ago

Null Values in Data Suddenly

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.

General Comment
Need Help

8 Replies

  • PijushRoy's avatar
    PijushRoy
    Community Champion
    1 year ago

    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

  • DineshYadl's avatar
    DineshYadl
    Helper I
    1 year ago

    Hi nmcquaid 

     

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

     

    Thanks

      • v-menakakota's avatar
        v-menakakota
        Community Support
        1 year ago

        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.