Character replacement on Teradata SQL import : "..." becomes "÷"

Hi slap33 , Thank you for reaching out to the Microsoft Community Forum.

This is caused by a character encoding mismatch between Teradata and Power BI. Specifically, Teradata may be using a default character set like LATIN, while Power BI expects UTF-8 or Unicode characters. You need to ensure the connection uses UTF-8 encoding from the start.

If you're connecting via ODBC, update your connection string or DSN settings to include CHARSET=UTF8. For example:

Driver={Teradata};DBCNAME=your_server;UID=your_user;PWD=your_password;CHARSET=UTF8;

This tells the Teradata driver to use UTF-8, so special characters like the ellipsis (…) are correctly interpreted. Once set, this change ensures the correct characters come through without needing to do any replacements or transformations afterward.

If this helped solve the issue, please consider marking it “Accept as Solution” so others with similar queries may find it more easily. If not, please share the details, always happy to help.
Thank you.