Forum Discussion

mrslyfox's avatar
mrslyfox
Helper II
8 years ago
Solved

Arithmetic overflow error converting expression to data type int.

Hello,  SQL statement:   declare @FromDate datetime, @ToDate datetime, @startdate AS DATETIME = GETDATE() set @FromDate = DATEADD(MONTH, DATEDIFF(MONTH, 0, @startdate) , 0) set @ToDate = DATE...
Need Help
v-sihou-msft's avatar
v-sihou-msft
Microsoft Employee
8 years ago

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,