I have an excel file as datasource and within the excel file, there is one column that contains long texts that have forced return within the text.
When pulling in the text field into PowerBI table visual, the forced return is shown as "_x000D_".
I'm surprised not very much has been discussed here on the forum. I tried using the Query Editor's "Replace Value" function selected "Carriage Return" under Advanced Options --> "Replace using special characters". But it didn't work.
Aside from going into Excel and use "Clean" formula to remove the forced returns, can the fix be done within PowerBI?