Forum Discussion

tomdicarlo's avatar
tomdicarlo
Regular Visitor
3 years ago
Solved

Arithmetic Operation Overflow

Hi, I'm trying to publish a report to the power bi web app, but whenever I attempt to refresh data, I get the following error message: We're sorry, an error occurred during evaluation.;Arithmetic ...
Need Help
  • GilbertQ's avatar
    GilbertQ
    3 years ago

    Hi tomdicarlo 

     

    Can you confirm that the data type you set for your column is Whole Number, that should then be a 64bit int which should be able to hold your value.

     

    Also if the data source has changed you should see that reflected in the lineage view, I would maybe re-publish the PBIX to make sure it is working as expected.

GilbertQ's avatar
GilbertQ
Super User
3 years ago

Hi tomdicarlo 

 

Can you confirm that the data type you set for your column is Whole Number, that should then be a 64bit int which should be able to hold your value.

 

Also if the data source has changed you should see that reflected in the lineage view, I would maybe re-publish the PBIX to make sure it is working as expected.

Ahmed-Gomaa's avatar
Ahmed-Gomaa
New Member
3 months ago

i have the same problem, and i'm sure all data types are fine

it go away once restart the excel file that contains that query

but i still don't know the main reason and how to solve it finally.