CODEWITHSUNDEEP
powerbi
Student of the Digital World
Student of the Digital World

Reputation: 3041

Replacing a special character in Power BI

How do we replace a special character in Power BI on query editor?

This is my data :

Corresponding Business Objects - PFMC

But it appears as

Corresponding Business Objects � PFMC

A question mark (?) with a 4 sided quadruple surrounded next to it. I am not able to use replace values. I copied in the � and tried to replace it with "-" but it is not working.

How can we fix this.

Upvotes: 1

Views: 7598

Answers (1)

Alexis Olson
Alexis Olson

Reputation: 40214

Both of the following work for me:

= Table.ReplaceValue(#"Previous Step","�","-",Replacer.ReplaceText,{"ColumnName"})

= Table.ReplaceValue(#"Previous Step",Character.FromNumber(65533),"-",Replacer.ReplaceText,{"ColumnName"})

The first line was generated from the Transform > Replace Values tool:

enter image description here

Upvotes: 2

Related Questions