Forum Discussion

axsup's avatar
axsup
New Member
8 years ago
Solved

Keep Null Values

Hello, I am importing data from SQL Server to Power BI Desktop that has NULL values, I can not load them because it gives me an error about the data type, I know I can replace the NULL with zero, but this won't be satisfactory for my data, because "0" and NULL mean different things in my dataset, 0 means no records were made, NULL means the data was hidden for privacy issues, if there any way to convert Nulls to BLANK  cells? Or there any other way to keep NULL without replacing it with "0"? Thank you.  

  • Hi axsup,

     

    Click replace value then replace null with ' ' as below:

     

    #"Replaced Value" = Table.ReplaceValue(dbo_Test,null," ",Replacer.ReplaceValue,{"Value", "Column"})

    Regards,

    Jimmy Tao

2 Replies

  • v-yuta-msft's avatar
    v-yuta-msft
    Community Support

    Hi axsup,

     

    Click replace value then replace null with ' ' as below:

     

    #"Replaced Value" = Table.ReplaceValue(dbo_Test,null," ",Replacer.ReplaceValue,{"Value", "Column"})

    Regards,

    Jimmy Tao