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...
Need Help
  • v-yuta-msft's avatar
    v-yuta-msft
    8 years ago

    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

v-yuta-msft's avatar
v-yuta-msft
Community Support
8 years ago

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's avatar
axsup
New Member
8 years ago

Thank you for your help!