Power Query Execution it took so much time

[Victor_sp]

Hi All,

  I don't know why it would take so much time to execute the query. I am waiting for more than 3hrs still now I didn't get it the data. please sort me out. here I attached the screenshot also.

Advanced Thanks

[Vijay_A_Verma]

Please post the value of RangeStart and End and few values from TXN_DATE..

[Victor_sp]

Hi @Vijay_A_Verma 

We are having 6 years of data only. whether we applied on that incremental refresh or not same time only it took.

[Vijay_A_Verma]

I want to validate whether RangeStart and End and TXN_DATE contain Date values or DateTime values. This is why I want to see the values there. If they contain date values only then you should use Date.From in your query not DateTime.From.