i'm using CDATA Odoo connector to import my db to power bi desktop but all special character like & or < are imported as &
Have a look at this Post.
this might help you.
@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
@v-yuezhe-msft in odoo the fieald are char type
@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