cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Advocate II
Advocate II

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

5 REPLIES 5
Helper I
Helper I

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.

Helper I
Helper I

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.

Microsoft
Microsoft

@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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

@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

@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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
secondImage

Happy New Year from Power BI

This is a must watch for a message from Power BI!

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors