Forum Discussion
Value was either too large or too small for a Decimal
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
Solution SageI 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.
Thanks for the answer,
I already had this same problem reading from an excel, for that reason I didn’t set any data type to decimal, I didn’t set any change to data types for that reason. The problem is my information, because this was working last Friday, but I’m not able to identify the source/column that is generating the problem to correct the information that is coming from DB.
the problem was solved when i identified that the issue was a variable that had a lot of decimals, but i identified this in the report schema in the power bi desktop, i look all of my sigle reports and realize that one of them had a lot of decimals.
I think that PBI has to let you know in the power bi service where are you having the problem, in what query or dashboard are you having the problem.
regards,
- sdjensen
fcosp if you want influence on how the product develops you should either search for an already existing idea and vote for it or create a new one here: https://ideas.powerbi.com/forums/265200-power-bi