Forum Discussion
Community ChampionPower Query - Clean Text didn't work
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,
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.
3 Replies
speedrampsSuper User
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
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,
- speedramps
