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:
DataSourceKind=Oracle
DataSourcePath=dwhse-prod:1530/dwhseprd
ErrorCode=29275

 

I have isolated the row and can anyone tell me how to get around that issue?

It is source = oracle.database("server",[query])

 

Thanks,

K3

Need Help

11 Replies

  • 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 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Anonymous k3rz0rg ,

     

    Any update on the request. How to handle this in Power BI. I am unable to import data from Oracle DB because of this language change.

     

    Thanks in advance.

    • Abhishekkl's avatar
      Abhishekkl
      Frequent Visitor
      1 year ago

      Only solution is to use cast in sql query and change data type to nvarchar , change the length as per original data type. Please reply if your issue is resolved.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Anonymous ,

     

    Is this issue resolved? If so could you please help me how to resolve it in power BI.

     

    I am facing same issue when i import data from Oracle Database to Power BI. Unable to load it to POWER BI.

     

    Any Solutions is highly appreciated.

     

    Thanks in advance.

  • DaniloTavecchio's avatar
    DaniloTavecchio
    Frequent Visitor
    2 years ago

    Hi, I have the same issue and I cannot understand what row or what column has the bad character in it . And furthermore The link above seem not working (404: Page not found) 

    Any help?

    • DaniloTavecchio's avatar
      DaniloTavecchio
      Frequent Visitor
      1 year ago

      Nope! Unfortunately the only way to bypass the issue is deleting rows and column (!) hoping the data you loose are not relevant