Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
jsureka
Regular Visitor

Power bI mongo atlas decimal128 value not parsing

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_0-1707741865140.pngjsureka_1-1707741875751.png

 

7 REPLIES 7
jsureka
Regular Visitor

Is there any way I can parse the values properly?

Can you recast them at the source?

Can you please explain how to recast at the source

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

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
Super User
Super User

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

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.