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

Shape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.

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
November Carousel

Fabric Community Update - November 2024

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

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.