Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

I've done it as well, adding these lines on the last working steps 

 

    #"Filtered Rows3" = Table.SelectRows(#"Renamed Columns", each ([Entity Group] <> "TPL")),
    #"Replaced Value" = Table.ReplaceValue(#"Filtered Rows3","",null,Replacer.ReplaceValue,{"Account Description"}),
    #"Trimmed Text" = Table.TransformColumns(#"Replaced Value",{{"Account Description", Text.Trim, type text}})
in
    #"Trimmed Text"

 

 But it still gave me the same error. I'm almost close to thinking that there's something wrong about how my sql and bi connection is set-up. Everything is working, except when I trim.

 

Thanks for the new approach. 

MisterNL's avatar
MisterNL
New Member
1 year ago

I had the same issue. I did a Clean in front of the Trim and it worked afterwards