Forum Discussion
Error in Trimming a Column
Hi, I'm working with a data imported from SQL database then to PowerBI. It's a direct import from power BI as we are not allowed to do anything through the MS SQLserver management studio So I h...
Hi Anonymous ,
could it be that you are pulling data from your SQL database that has blank values "" instead of null values?
If so, you can put this statement before your trim step:
= Table.ReplaceValue(#"FilteredRows3","",null,Replacer.ReplaceValue,{"Account Description"})