[DataSource.Error] ODBC: Error [22003] Numeric value out of range

[MigueGP]

Hi

I have one power bi file (pbix) with 3 tables querys, with ODBC connection to database. The first two table querys loads perfect, but when I try to load a specific third query (individually) I get the next error:

[DataSource.Error] ODBC: Error [22003] Numeric value out of range

I didn't found any older post with the exact same error. Can you please share thoughts about why this happens, or what can I try in power bi desktop to solve this issue.

I've try to find a number too large in database that couldn't be contained by the declared field or any other erros, but no success.

Also I find the error kind of odd in Power BI, because the exact same table query is loaded in Qlikview and is working fine.

Hope any of you can help me with this.

Greeting

MB

[v-yueyunzh-msft · Accepted solution]

Hi , @MigueGP

The error message you are seeing indicates that a numeric value in your data is outside the range that can be represented by the data type used to store it. This can happen if the data type of the column in your database is not compatible with the data type used in your Power BI query.

To resolve this issue, you can try the following steps:

1 Check the data type of the column in your database and make sure it is compatible with the data type used in your Power BI query.

2 Check the data in the column to see if there are any values that are outside the range of the data type used.

3 If the data type is correct and there are no values outside the range, try refreshing the data in your Power BI query to see if the issue is resolved.

4 If the issue persists, you may need to modify your query to handle the data differently, such as by converting the data type or filtering out values that are outside the range.

For more related Q&A regarding the issue code you met, please check these links:

mysql - SQLSTATE[22003]: Numeric value out of range: 1264 Out of range value - Stack Overflow

php - SQLSTATE[22003]: Numeric value out of range: 1264 Out of range value for column 'contact' at r...

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

Best Regards,

Aniya Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly