Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

mauroanelli

error importing special character from Odoo db

Submitted by Helper I on ‎03-20-2019 02:50 AM

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
See more ideas labeled with:
6 Comments (6 New)
Comments
Anonymous
Not applicable
‎03-20-2019 10:28 PM

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

Anonymous
Not applicable
‎03-21-2019 12:24 AM

@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

Anonymous
Not applicable
‎03-21-2019 12:24 AM
 
mauroanelli
Helper I
Helper I
‎03-21-2019 02:16 AM

@Anonymous  in odoo the fieald are char type

Anonymous
Not applicable
‎03-27-2019 02:38 AM

@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
Helper I
‎03-27-2019 02:41 AM

me too

Idea Statuses