Forum Discussion

Helper I

5 years ago

Solved

BI replace value function automatically add special character while replacing.

Hi all, I replaced value using bulit in function but BI automatically selects replace using speacial character and then selects non-breaking space. Can anyone guide me how can I set clean my data in...

Tips and Tricks

v-kelly-msft
5 years ago
Hi HassanMoosa ,

Check a similar thread which may help:

https://social.technet.microsoft.com/Forums/ie/en-US/a78442d1-584e-464e-b1d4-c512746bfa25/how-to-replace-special-characters?forum=powerquery

Or Check the blog below for bulk replace values in power query:

https://www.syntelli.com/easy-guide-to-bulk-replace-values-in-power-bi-or-power-query

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

Community Support

5 years ago

Hi HassanMoosa ,

Check a similar thread which may help:

https://social.technet.microsoft.com/Forums/ie/en-US/a78442d1-584e-464e-b1d4-c512746bfa25/how-to-replace-special-characters?forum=powerquery

Or Check the blog below for bulk replace values in power query:

https://www.syntelli.com/easy-guide-to-bulk-replace-values-in-power-bi-or-power-query

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

Related content