Odbc driver returned a decimal that is out of range, Power BI

29 Views Asked by At

I am trying to import data from mongodb using the atlas sql connector in power bi. i have downloaded the atlas odbc driver too. Most data are retrieved properly but the decimal128 fields throw an error quoting " The odbc driver returned a decimal that is out of range or cannot be understood.

Is there any solution to this? enter image description hereenter image description here

I tried transforming the values into text and decimal, but no luck. But when I change the type of data from decimal128 to double, it works perfectly.

0

There are 0 best solutions below