Forum Discussion
Value was either too large or too small for a Decimal
Hi Everyone,
I’m having a problem when I’m trying to update the data from the database, if I execute manually or the automated update from the web I’m getting this error: Value was either too large or too small for a Decimal.
If I updated the information from the PB desktop I don’t get the error.
I understand that the problem is that the data it’s bigger that than the column, but the error don't say what query is generating the problem, I have almost 20 queries to DB and I can't identify where the problem is.
I look in the forum and in the tutorial but I couldn’t find how to solve this.
Regards,
Federico
6 Replies
- ankitpatira
Community Champion
fcosp are you able to expand that and see details ? if not i guess you will have to take a guess where you have used decimal number and check that. You can also look at your reports in power bi desktop and compare it with power bi service and spot the difference to find report or visual where you may have used decimal number field.
Thanks for the answers,
It’s already expanded, it’s all the detailed error.
I check out and I don’t have any data field in the tables of Power Bi with the type Decimals.
It’s really strange because the report from power bi desktop I updated and publish correctly buy I’m not able to update from web the same report.
Federico
- sdjensen
Solution Sage
I would suspect that you somewhere in your queries have a column that is initially is read as a decimal and then changed to another data type (you say you don't have any columns of with the type decimal) or you have a Change Type task that try to change a source value to decimal and then later you change it to something else.
