topic Re: Arithmetic overflow error converting expression to data type int in Dataflow

Arithmetic overflow error converting expression to data type int

fbrodrigues95 — Wed, 21 Feb 2024 17:47:34 GMT

Hi everbody,

Im in the dataflow stage and after doing my data transformation and assign each collumn to my data warehouse im getting this message error:

"Couldn't refresh the entity because of an issue with the mashup document MashupException.Error: DataSource.Error: Microsoft SQL: Arithmetic overflow error converting expression to data type int. Statement ID: {8729CA0A-7822-45E2-A9DE-F1BFA8CA7F32} | Query hash: 0x6C55E09B9813014B | Distributed request ID: {41EEC309-8EAB-4EBC-8F66-15A6AF437259} Details: Reason = DataSource.Error;DataSourceKind = Warehouse;DataSourcePath = Warehouse;Message = Arithmetic overflow error converting expression to data type int. Statement ID: {8729CA0A-7822-45E2-A9DE-F1BFA8CA7F32} | Query hash: 0x6C55E09B9813014B | Distributed request ID: {41EEC309-8EAB-4EBC-8F66-15A6AF437259};ErrorCode = -2146232060;Number = 8115;Class = 16;State = 2;Microsoft.Data.Mashup.Error.Context = Use"

Can someone help me understand what im doing wrong?

Re: Arithmetic overflow error converting expression to data type int

HimanshuS-msft — Wed, 21 Feb 2024 19:50:36 GMT

Hello fbrodrigues95
Thanks for using the Fabric community.
The error means that the one of the column which is defined as int and having an value which it cannot hold .

May be the column is defined as int but the value which you are passing in non-int .
Thanks
HImanshu

Re: Arithmetic overflow error converting expression to data type int

v-cboorla-msft — Thu, 22 Feb 2024 11:41:24 GMT

Hi fbrodrigues95

Glad that your query got resolved.

Please continue using Fabric Community for any help regarding your queries.

Thanks.