Get 'We cannot apply field access to the type Number.' when a new column transform value

[scheung]

Hi,

I want to create a new column in my PowerBI data table, which is calling 'TextEncoding.UTF of another column.

In the new column, I put this in the column forumla:

= TextEncoding.Utf8[Name]

But I get error 

Expression.Error: We cannot apply field access to the type Number.
Details:
Value=65001
Key=Name

The column is in not in type Number, it is in type Text.

[mahoneypat]

If that is a function, the column needs to be wrapped in ( ).  It looks more like a parameter.  Is that to be used in the BinaryFormat.Text( ) function like BinaryFormat.Text([Name], TextEncoding.UTF8)?

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat

[scheung]

Thanks.  I tried using this as my Custom column formula:

BinaryFormat.Text([MyColumnName], TextEncoding.Utf8)

but i get this error now:

Expression.Error: We cannot convert the value "{MyColumnCell}..." to type Number.
Details:
Value={MyColumnCell}
Type=[Type]

[V-lianl-msft]

Hi @scheung ,

Try this:

Text.FromBinary(Text.ToBinary([Column1]),TextEncoding.Utf8)

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[scheung]

Thanks for your answer. Your formula works. But when I try that I still see non readable characters in some of the cell values in my data table.  I think those characters are non english characters (e.g. japanese characters). do you know how can I convert them so that i can display them correctly in PowerBI?