Forum Discussion
DATEDIFF_BIG Azure DW Direct Query
Hmm, well, I don't know about that or whose responsibility it would be to fix that issue, the Power BI team or the Azure DW team. Your best bet is to log an Issue here in the Power BI community and see what feedback you get. I didn't see an existing issue out there when I checked:
https://ideas.powerbi.com/forums/360879-issues
Greg_Deckler, dilkushpatel I got the information from our senior engineers that it is an error in the documentation: the function DATEDIFF_BIG is not actually supported in Azure SQL DW. So, that is the reason why you get that error message. A defect is issued to fix the documentation issue, however, no ideas about when this function is going to be available in Azure SQL DW. Thanks for reporting this issue!
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?
