Forum Discussion
axsup
8 years agoNew Member
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-msftCommunity 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
- axsupNew Member
Thank you for your help!