error importing special character from Odoo db

[mauroanelli]

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

[Anonymous]

Have a look at this Post.

this might help you.

https://seddryck.wordpress.com/2017/01/08/handling-special-characters-from-html-files-with-power-bi-...

[v-yuezhe-msft]

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


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

Regards,
Lydia

[mauroanelli]

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

[v-yuezhe-msft]

@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]

me too