Forum Discussion

dilkushpatel's avatar
dilkushpatel
Icon for Helper III rankHelper III
10 years ago

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...
Need Help
Show and Tell
dilkushpatel's avatar
dilkushpatel
Icon for Helper III rankHelper III
10 years ago

Vicky_Song

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

Vicky_Song's avatar
Vicky_Song
Icon for Impactful Individual rankImpactful Individual
10 years ago

dilkushpatel, could you please offer more information about on which steps the DATEDIFF function is converted to DATEDIFF_BIG?