Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

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
Anonymous
Not applicable
v-yuezhe-msft
Employee

@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

v-yuezhe-msft
Employee
Status changed to: Needs Info
 
mauroanelli
Helper I

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

v-yuezhe-msft
Employee

@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

mauroanelli
Helper I

me too