Forum Discussion

k3rz0rg's avatar
k3rz0rg
Icon for Advocate III rankAdvocate III
8 years ago

How to get around with partial multibyte character issue?

Hi all,   I've been working with oracle db and lately facing an issue regarding partial multibyte character.  it says   DataSource.Error: ORA-29275: partial multibyte character Details: DataSo...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

k3rz0rg,

I have no issues connecting to Oracle and writing SQL query in Power BI Desktop. Have you tried to execute the SQL query in SQL developer and check if it is successful?

Regards,
Lydia

  • k3rz0rg's avatar
    k3rz0rg
    Icon for Advocate III rankAdvocate III
    8 years ago

    Anonymous

     

    Well, connecting to oracle is good; it's the point of entry where the user inserted the data in different characterset. We have users all around the world and problem occurs mostly from the euro side when they use special characters for names or addresses in their own utf or ascii sets.

    I've been looking for a way to convert that while fetching the data with query.

     

    -K3

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi ,
    Even I am facing same issue when I upload to report to PBI services and yes I am using SQL Query did transformation on that particular column but nothing is working for now.
     Any suggestion appreciated