Arithmetic overflow error converting expression to data type int.

[mrslyfox]

Hello, 

SQL statement:

declare
@FromDate datetime,
@ToDate datetime,
@startdate AS DATETIME = GETDATE()
set @FromDate = DATEADD(MONTH, DATEDIFF(MONTH, 0, @startdate) , 0)
set @ToDate = DATEADD(SECOND, -1, DATEADD(MONTH, 1, DATEADD(MONTH, DATEDIFF(MONTH, 0, @startdate) , 0) ) )
exec pS_ST32_Machines_All 110, @FromDate,@ToDate
select * from Print_Machines_All where ReportId = 110

No issues with SSMS
but PowerBI return Arithmetic overflow error converting expression to data type int.

[ChristianGeiger]

Hallo,

i know this is old, bute maybe someone get along this thread.
in my case i had an issue with the source datatype. I divided a column with 1000 and when the sourc colum was a 'whole number' it worked.

When choosing a different columne the data was a 'whole number'(int) but the datatype was  'decimal' after changeing the datytype it worked.

[v-sihou-msft · Accepted solution]

@mrslyfox

Can you open SQL Profilter to check statement that passed to SQL Server when executing your SQL Statement? It may have issue when parsing the SQL statement in Power Query Advanced Editor. 

Also I suggest you use query parameter instead of declaring variable in your statement. Please refer to a similar thread below:

https://community.powerbi.com/t5/Integrations-with-Files-and/parameters-to-SP-or-Sql-query/m-p/58337

Regards,