Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Power Query Execution it took so much time

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

 

Need Help
Show and Tell
Tips and Tricks

3 Replies

  • Vijay_A_Verma's avatar
    Vijay_A_Verma
    Most Valuable Professional
    4 years ago

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      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's avatar
        Vijay_A_Verma
        Most Valuable Professional
        4 years ago

        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.