Selected Table Cannot Be Folded for Direct Query

[Anonymous]

Hi,

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

[amitchandak · Accepted solution]

@Anonymous , Incremental refresh in Direct query?

Not very clear

[amitchandak · Accepted solution]

@Anonymous , Incremental refresh in Direct query?

Not very clear

[Anonymous]

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 · Accepted solution]

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.