remove errors rows

Hello Anonymous , what do you mean by remove error rows without losing original data?

You want the error values to be replaced with null then

you can do something like this

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45W8nNUitWJVvLNz0jMA7MMDQyUYmMB", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Name = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Name", Int64.Type}}),
    #"Replaced Errors" = Table.ReplaceErrorValues(#"Changed Type", {{"Name", null}})
in
    #"Replaced Errors"