Forum Discussion
Gateway Timeout Error - Incremental Refresh
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?
3 Replies
Is it reproducible? Have you tried using the ODBC driver instead? Have you raised a ticket?
Hi AlessioChiaramo ,
Thanks for the reply from lbendlin , please allow me to provide another insight:
There are several possible reasons for incremental refreshout outouts:
- Data source query is not folded
The solution is to verify the query fold.
- 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.
- 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 TeamIf 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!And you have a working gateway which you use regularly for other refreshes? Cloud or on-prem.
Regards.
