Gateway Timeout Error - Incremental Refresh

[AlessioChiaramo]

Hi All, 

I'm testing the incremental refresh on a large data model.

The data source is VERTICA DB with native connector.

When I published the dataset there are no errors. But when I reloaded the data on powerBI online for the first time I get this error:

{"error":{"code":"DM_GWPipeline_Gateway_AdoNetProviderExecuteQueryTimeoutError","pbi.error":{"code":"DM_GWPipeline_Gateway_AdoNetProviderExecuteQueryTimeoutError","parameters":{},"details":[],"exceptionCulprit":1}}}

Can anyone help me solve the problem?

[sergej_og]

And you have a working gateway which you use regularly for other refreshes? Cloud or on-prem.

Regards.

[Anonymous]

Hi @AlessioChiaramo ,

Thanks for the reply from lbendlin , please allow me to provide another insight:

There are several possible reasons for incremental refreshout outouts:

1. Data source query is not folded

The solution is to verify the query fold.

2. The data loaded to partition is too large

The solution is to reduce the size of the model, enable the large model storage format or start the initial refresh.

3. Inquiry may be limited by the default time limit of the data source.

The solution is to cover the time limit in the inquiry expression.

For more relevant information, please refer to the official document below:

Troubleshoot incremental refresh and real-time data in Power BI - Power BI | Microsoft Learn

If you have other questions, please contact me at any time.

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

[lbendlin]

Is it reproducible?  Have you tried using the ODBC driver instead?  Have you raised a ticket?