Keep Null Values

[axsup]

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.  

[v-yuta-msft · Accepted solution]

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

[axsup]

Thank you for your help!