Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
rsbin
Super User
Super User

Power 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,

1 ACCEPTED SOLUTION
speedramps
Super User
Super 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.

View solution in original post

3 REPLIES 3
speedramps
Super User
Super User

Hi again rsbin

 

Glad I could help and solve your problem.

speedramps
Super User
Super 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.

@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,

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.