Hi,
i'm using CDATA Odoo connector to import my db to power bi desktop but all special character like & or < are imported as &
any help?
thanks
6 Comments
- AnonymousNot applicable
Have a look at this Post.
this might help you.
- AnonymousNot applicable
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 - AnonymousNot applicable
- mauroanelli
Helper I
Anonymous in odoo the fieald are char type
- AnonymousNot applicable
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