Text.Clean does not clean UNICHAR(158) or UNICHAR(8206)

[ruicaio]

Hi.

My data sometimes come with UNICHAR(158) or UNICHAR(8206) and Text.Clean does not clean those unprintable chars.

In function help says "Returns the original text value with non-printable characters removed."

Thank You for any help.

[v-qiuyu-msft]

Hi @ruicaio,

Which data source do you get data from? How do you store UNICHAR(158) or UNICHAR(8206) values in source? Would you please share a source file if possible? 

Best Regards,
Qiuyun Yu 

[ruicaio]

Hi

The data source is a Calendar from O365

Sample here:

https://drive.google.com/open?id=1XszmlxmutUCt1u4OHlxQCofyAYMIgIzB

Thank you

[v-qiuyu-msft]

Hi @ruicaio,

I'm not able to see detail data in Query Editor to understand the issue you mean via your pbix file, please share screenshots about Trimmed Text and Cleaned Text steps, and points out where the issue you mean about UNICHAR(158) or UNICHAR(8206). 

Best Regards,
Qiuyun Yu