Forum Discussion

slap33's avatar
slap33
Helper I
1 year ago
Solved

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

Hi there,   i encounter an issue probably related to regional settings but i dk how to solve it.   i do a sql extraction to get data from a Teradatabase.   Values i wanna get should look like t...
Need Help
  • v-hashadapu's avatar
    v-hashadapu
    1 year ago

    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.

v-hashadapu's avatar
v-hashadapu
Community Support
1 year ago

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

This issue may be related to character encoding mismatches between the Teradata database and Power BI.

Please refer below steps to help resolve this:

  1. Ensure that your Teradata database is using the correct character encoding (e.g., UTF-8). You can check this in the database settings or by querying the database metadata.
  2. Use Correct Functions like using SQL functions like TRANSLATE or REPLACE to handle special characters. Example:

SELECT TRANSLATE(column_name, '÷', '') AS cleaned_column

FROM your_table;

  1. Ensure that your SQL session is using the correct locale settings. You can set this in your SQL client or within the SQL query itself.
  2. Update Regional Settings in Power BI, Go to File > Options > Regional Settings. Ensure that the regional settings match the expected format for your data.
  3. Export the data to a CSV file and check if the issue persists. This can help isolate whether the problem is with the database or the tool.

If this helps, please consider marking it 'Accept as Solution' so others with similar queries may find it more easily. If not, please share the details.
Thank you.