Forum Discussion
transform clean command
I think I am experiencing problems with the Power BI > Transform > Clean command. What is the clean command supposed to do please? I thought it simply removed invisible characters, but I have disco...
Text.Clean removes unprintable characters from a text string.
Your test is rather indirect: can't you just perform row counts before and after applying Text.Clean?
RowsBefore = Table.RowCount(MyTable)
RowsAfter = Table.RowCount(#"Cleaned Text")
If there is a difference, you can investigate which records are missing by merging the tables.
Otherwise I have no explanation for the missing records.