Power Query - Clean Text didn't work

[rsbin]

Good Afternoon,

I am importing data from SQL.  One value in particular is yielding a "messy" result.

I believe the origin is that SQL doesn't handle apostrophes particularly well.  The true origin is UKG's Payroll system.

This individual's name is O'Bxxx.

O�Bxxx,

I tried the Clean Text function in Power Query, but it didn't provide any change.

Wondering if anyone else has encountered a similar issue and is there a fix for this?  Kinda looks weird when I create a Table or other Visuals in my PBI Report.

Thanks and Regards,

[speedramps]

Hi again rsbin

Glad I could help and solve your problem.

[speedramps · Accepted solution]

Sometimes you need to do data cleansing.
Consider adding a step in the Power BI query to replace � with '.
Click here for example 
Remember we are uppaid Power BI volunteers , so please click the thumbs up and solve button to leave kudos. Thank you.

[rsbin]

@speedramps ,

Didn't think of capturing and copying the symbol.  Looks like what you showed me will work.

Will try it once I am back in my office.  Thanks much for the solution.

Enjoy your weekend and Kind Regards,