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.

tomdicarlo's avatar
tomdicarlo
Regular Visitor
3 years ago

Hi Gibert,

 

Thanks for the feedback. I double checked, and it turns out that some of the helper queries that were automatically created by the Desktop App included references to the old blob storage account. Still a bit strange that it was causing an arithmetic overflow, but removing those references fixed the problem for me. Thanks again!

GilbertQ's avatar
GilbertQ
Super User
3 years ago

Thanks for letting us know!