Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Selected Table Cannot Be Folded for Direct Query

 

Hi,

 

Can we do incremental reresh without option 3 as shown in below screenshot

 

Need Help
  • v-kkf-msft's avatar
    v-kkf-msft
    4 years ago

    Hi Anonymous ,

     

    When published to the Service, the first refresh will refresh all the data, and only after that will incremental refreshes be performed.

     

    So are you having an initial refresh timeout? Then please refer to this document to check the following factors.

    Troubleshoot incremental refresh and real-time data 

    • Data source queries aren't being folded
    • Data loaded into partitions is too large
    • Data source query timeout

     

     

    If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
    Best Regards,
    Winniz
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

3 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    Anonymous , Incremental refresh in Direct query?

     

    Not very clear

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hi amitchandak,

       

      I have implemented incremental refresh and published to service, But still i am getting timeout issue. Is that timeout coming because of third option not checked as per below screenshot.

       

      • v-kkf-msft's avatar
        v-kkf-msft
        Community Support
        4 years ago

        Hi Anonymous ,

         

        When published to the Service, the first refresh will refresh all the data, and only after that will incremental refreshes be performed.

         

        So are you having an initial refresh timeout? Then please refer to this document to check the following factors.

        Troubleshoot incremental refresh and real-time data 

        • Data source queries aren't being folded
        • Data loaded into partitions is too large
        • Data source query timeout

         

         

        If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
        Best Regards,
        Winniz
        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.