Problem With Decimals in Oracle Database Connection (ORA-01722: invalid number)

[DanielMP]

Hello community,

I'm having some issues with PowerBI Desktop version 2.124.2028.0. When I connect to the Oracle Database Connection of my company, there is a problem importing a view that have a relation with other table that has a number field defined as VARCHAR that has commas "," as decimals separator instead of dots ".". The error reported is: 

[DataSource.Error] Oracle: ORA-01722: invalid number

I didn't have this problem in previous version when importing mode, and If I run this code through SQL Developer it runs perfectly. I can´t change the type of this field, and I can't do anything about the view because that view is related to another view that is related to another view... that is related to the original problematic table, all their are managed for my company. Anybody knows what could I do in order to solve this problem?? 

Thanks all!!  

[DanielMP · Accepted solution]

*****UPDATE*****

I JUST SOLVED THE PROBLEM. I have to go to: edit enviroment variables for this acccount / or this system (if you have privileges) and set the variable name: NLS_NUMERIC_CHARACTER, and set value: ,.

[Anonymous]

Hi @DanielMP ,

I'm glad to hear that you solved your problem. Could you please post your solution as a reply below and mark it as answer so that more users facing the same problem can find the solution faster? Thank you!

Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.