Hi guys,
I have configured incremental setup for my report, which is of huge dataset. We had to limit the daterange to 1 year for development. For incremental refresh, for full load I gave 2 years and incremental refresh time as 7 days. I published the report in premium per user workspace. But I get error and not sure which query is causing the error. Query folding is enabled only for some queries and not for others since some of them are native queries. (No other way)
I got the below errors for each refreshes.
{"error":{"code":"DM_GWPipeline_Gateway_TimeoutError","pbi.error":{"code":"DM_GWPipeline_Gateway_TimeoutError","parameters":{},"details":[],"exceptionCulprit":1}}}
Microsoft SQL: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
Is there something that needs to be done or configured or changed? I exported the gateway logs as well but not sure where to look for the answers. Where do i have to check to know what is causing the issue for refresh error, in the gateway logs.
Please help.
