Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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
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
Thank you for your help!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
82 | |
70 | |
61 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |