Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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,
Solved! Go to 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.
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.
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,
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |