Forum Discussion

fcosp's avatar
fcosp
Frequent Visitor
10 years ago

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 lar...
ankitpatira's avatar
ankitpatira
Icon for Community Champion rankCommunity Champion
10 years ago

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.

 

fcosp's avatar
fcosp
Frequent Visitor
10 years ago

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's avatar
    sdjensen
    Icon for Solution Sage rankSolution Sage
    10 years ago

    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.

    • fcosp's avatar
      fcosp
      Frequent Visitor
      10 years ago

      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.

      • fcosp's avatar
        fcosp
        Frequent Visitor
        10 years ago

        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,