Forum Discussion
Arithmetic Operation Overflow
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.
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.
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!
Thanks for letting us know!
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.
