Arithmetic Operation Overflow

[tomdicarlo]

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 operation resulted in an overflow. Arithmetic operation resulted in an overflow. Arithmetic operation resulted in an overflow. Arithmetic operation resulted in an overflow. Arithmetic operation resulted in an overflow. Arithmetic operation resulted in an overflow. Arithmetic operation resulted in an overflow.. The exception was raised by the IDbCommand interface. 

When I refresh locally on Power BI Desktop, this issue doesn't present at all, only when refreshing my dataset on https://app.powerbi.com.

It is worth nothing that the dataset does include some very large numbers(the largest I'm seeing is 144208105256978.16), so if there is anything I would need to do to accomodate larger numbers on the web app, I could try making those changes.

I'm also not sure if this is relevant, but I recently changed the blob storage account I am pulling my data from, which coincided with the first failure to refresh, though the content of the blob storage account should have been mostly identical. It is still showing the old blob storage account in the data lineage on the web app even though the old storage account is no longer in use.

Thanks for any help anyone can offer!!

[GilbertQ · Accepted solution]

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]

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]

Thanks for letting us know!