OLE DB or ODBC error: Exception from HRESULT: 0x80040E57

If you’re having “OLE DB or ODBC error: Exception from HRESULT: 0x80040E57.“ error during refreshes, there is a solution.

First of all, it’s always best to narrow issue down to specific step in your Power Query transformations.

In my case issue was happening for custom columns added. However, whenever I was refreshing preview - it wouldn't occur. Only during application of changes it would fail.

As the next step, I went to google the error code itself - HRESULT: 0x80040E57.

“Arithmetic overflow error converting expression to data type int.“ documentation stated.

Here's something that might surprise you: I've heard from more than a few developers that Currency data type has more precision. Contrary to that belief, Currency data type in Power BI doesn't actually provide more precision than other numeric types. In fact, it has fixed precision and can handle fewer digits than Decimal.

Key differences:

Currency type:

Range: -922 trillion to +922 trillion
Fixed 4 decimal places
Uses 8 bytes of storage

Decimal type:

Can handle numbers approximately 100 billion times larger than Currency type
Up to 28-29 significant digits
Uses 16 bytes of storage

To put this in perspective: If Currency type can handle amounts up to about 922 trillion, Decimal type can work with numbers in the septillions (that's a trillion trillions). Important DAX Consideration: Using Currency type affects ALL calculations in your measures. Every mathematical operation will be performed with reduced precision, which can lead to cumulative rounding errors in complex calculations. It has it's uses, but should me used mindfully taking into account reduced precision.

Now, in my case "Arithmetic overflow error" was an issue in the calculation itself, generating huge numbers, combined with Currency data type. However, it's important to know the difference.

If you’re having “OLE DB or ODBC error: Exception from HRESULT: 0x80040E57.“ error during refreshes, there is a solution.

First of all, it’s always best to narrow issue down to specific step in your Power Query transformations.

In my case issue was happening for custom columns added. However, whenever I was refreshing preview - it wouldn't occur. Only during application of changes it would fail.

As the next step, I went to google the error code itself - HRESULT: 0x80040E57.

“Arithmetic overflow error converting expression to data type int.“ documentation stated.

Key differences:

Currency type:

Range: -922 trillion to +922 trillion
Fixed 4 decimal places
Uses 8 bytes of storage

Decimal type:

Can handle numbers approximately 100 billion times larger than Currency type
Up to 28-29 significant digits
Uses 16 bytes of storage

Now, in my case "Arithmetic overflow error" was an issue in the calculation itself, generating huge numbers, combined with Currency data type. However, it's important to know the difference.