DATEDIFF_BIG Azure DW Direct Query

Question

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 SQL Azure DW so not sure why the error.&nbsp;It is a direct query connection to SQL Azure DW.&nbsp;Thanks,Dilkush

greg_deckler · Answer

See the thread here;http://community.powerbi.com/t5/Desktop/DATEDIFF-error-in-DirectQuery-against-SQL-database/td-p/27615&nbsp;

dilkushpatel · Answer

So this is a bug which is supposed to be fixed correct?Greg_Deckler

greg_deckler · Answer

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

vicky_song · Answer

Greg_Deckler,&nbsp;dilkushpatel I got the information from our senior engineers that&nbsp;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&nbsp;documentation issue, however,&nbsp;no ideas&nbsp;about when this function is going to be available in&nbsp;Azure SQL DW. Thanks for reporting this issue!

dilkushpatel · Answer

Vicky_SongI 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 SQLSo I guess that needs to change as data source won't be SQL 2016 on prem always.&nbsp;Let me know If I'm wrong.&nbsp;-Dilkush

Forum Discussion

DATEDIFF_BIG Azure DW Direct Query

6 Replies

Related content

Fabric & Azure Data User Group Program Requirements & Benefits

Azure databricks with direct lake semantic model

Mirroring Azure SQL

Bi-Directional filtering

Direct Lake