How to get around with partial multibyte character issue?

[k3rz0rg]

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

[Kishore001]

Did you got the solution, I am facing this issue currently

[DaniloTavecchio]

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

[DaniloTavecchio]

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?

[Anonymous]

Hi @v-yuezhe-msft ,

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.

[Anonymous]

Hi @v-yuezhe-msft @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]

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.

[v-yuezhe-msft]

@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

[Abhishekkl_09]

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 

[k3rz0rg]

@v-yuezhe-msft

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

[v-yuezhe-msft]

@k3rz0rg,

How about you use the function described in the following blog to convert the row?

http://www.dba-oracle.com/t_ora_29275_partial_multibyte_character.htm

Regards,
Lydia

[Abhishekkl_09]

This link is not working