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

[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.

[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

[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