Forum Discussion
DATEDIFF_BIG Azure DW Direct Query
Hi, I have used DATEDIFF and I think it is getting translated to DATEDIFF_BIG on backend and there it is giving error that function is not recognised. As per online docs function is available in SQ...
I think main problem that I see is Power Bi is translating DATEDIFF function tp DATEDIFF_BIG which is not supported in Azure DW or older versions of SQL
So I guess that needs to change as data source won't be SQL 2016 on prem always.
Let me know If I'm wrong.
-Dilkush
dilkushpatel, could you please offer more information about on which steps the DATEDIFF function is converted to DATEDIFF_BIG?