Forum Discussion
Error Power BI - Incremental Refresh - Timeout
Hi All,
I'm testing the incremental refresh on PowerBI.
I am using PowerBI Desktop to publish the app on PowerBi online
The data source is SAP HANA with ODBC connector.
I connected my HANA data source using on-premise data gateway to test the incremental refresh.
When I published the app (data source & app) there are no errors. But when I reloaded the data on powerBI online for the first time I get this error:
who can help me ?
maybe the solution is to increase the timeout time, could someone tell me how? using ODBC HANA?
Thanks
5 Replies
Hi Anonymous ,
Scheduled refresh timeout
Scheduled refresh for imported datasets timeout after two hours. This timeout is increased to five hours for datasets in Premium workspaces. If you encounter this limit, consider reducing the size or complexity of your dataset, or consider breaking the dataset into smaller pieces.https://docs.microsoft.com/en-us/power-bi/refresh-troubleshooting-refresh-scenarios
Hi mwegener ,
I reduced the dataset to test the incremental refresh. But it stopped less than 2 hours with the same error.
On request 8/5/2020, 13:37:14 - 8/5/2020, 14:21:38
Failed An error occurred while processing the data
{"Error": {"code": "DM_GWPipeline_Gateway_TimeoutError", "pbi.error": {"code": "DM_GWPipeline_Gateway_TimeoutError", "parameters": {}, "Details": [], "exceptionCulprit": 1}} }
I am testing the refresh action on power BI online , not scheduled refresh action.
maybe it doesn't depend on the subscription
Thanks
Hi Anonymous ,
take a look at this.
https://community.powerbi.com/t5/Service/DM-GWPipeline-Gateway-TimeoutError/m-p/1029967
Hi,
You can't set the Timeout with ODBC Hana connector.
The incremental refresh is it available for the default connector HANA (not ODBC).If the incremental refresh is available for your application you can see the Native query in edit query.
You can see my post https://community.powerbi.com/t5/Desktop/Error-Power-BI-Incremental-Refresh-Timeout/m-p/1081796#M500918
