Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Please see this thread. Power Query Changing Text Characters to Symbols - Microsoft Power BI Community - it contains a link to the user's Excel file that you can repro with
What is happening is when Power Query in Power BI imports the text in this Excel file, the data in being converted to ASCII symbols at the import. The user cannot modify this behavior. So data that looks like this:
is converted to this on the SOURCE line - no transformations were done, it was just imported incorrectly.
Note that if you open the Excel file and use Excel's Power Query to import the data, it is imported correctly. I have confirmed there are no formatting issues in the original excel file. copying all data to a new file as text only does not fix the issue.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.