Power bI mongo atlas decimal128 value not parsing

[jsureka]

Hi, I have been trying to load the Mongo Atlas data in the Power BI. I am stuck at a point where the fields with type decimal128 throw an error in Power BI. It says "DataSource.Error: The ODBC driver returned a decimal value for column 'AdditionalShippingCharge' that we couldn't understand or is out of range". 

I have used the changed type but no luck 
= Table.TransformColumns(#"Changed Type",{{"AdditionalShippingCharge", each Number.Round(_, 4), Decimal.Type}})

I am using 

Power BI Desktop

Mongo Atlas ODBC Connector ( beta )

Mongo BI Connector

[jsureka]

Is there any way I can parse the values properly?

[lbendlin]

Can you recast them at the source?

[jsureka]

Can you please explain how to recast at the source

[lbendlin]

Decimal128 Explicit Conversion (Decimal128 to Decimal) (mongodb.github.io)

[jsureka]

I need to keep decimal128 at the db. I want a way around with decimal128 in power. I tried to transform column in power bi query. but still it says the same error

[lbendlin]

Then you need to find a different BI tool that can handle these larger numbers.

If this is important to you please consider voting for an existing idea or raising a new one at https://ideas.fabric.microsoft.com/?forum=2d80fd4a-16cb-4189-896b-e0dac5e08b41

[lbendlin]

I think Power BI is maxing out at 64bit values.