cancel
Showing results for 
Search instead for 
Did you mean: 

error importing special character from Odoo db

Hi,

i'm using CDATA Odoo connector to import my db to power bi desktop but all special character like & or < are imported as &amp;

any help?

 

thanks

Status: Needs Info
Comments
Regular Visitor
Moderator

@mauroanelli ,

How about you store these special characters in other data sources such as Excel and SQL database? I make a test using these data source, & and < are imported into Power BI Desktop as expected.
1.PNG

What is the data type of this field in your data source?

Regards,
Lydia

Moderator
Status changed to: Needs Info
 
Regular Visitor

@v-yuezhe-msft  in odoo the fieald are char type

Moderator

@mauroanelli ,

I make a test when creating field in SQL Server with char type, everything works from my end, what is your Power BI Desktop version? I am using Power BI Desktop March release(2.67.5404.801).

Regards,
Lydia

Regular Visitor

me too

Idea Statuses