Error Power BI - Incremental Refresh - Timeout

[Anonymous]

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:

On Demnad 7/5/2020, 13:01:41  - 7/5/2020, 15:01:58 Failed There was an error when processing the data in the dataset.

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

who can help me ?

maybe the solution is to increase the timeout time, could someone tell me how? using ODBC HANA?

Thanks

[Anonymous]

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#M50...

[mwegener]

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

[Anonymous]

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 

[mwegener]

Hi @Anonymous ,

take a look at this.

https://community.powerbi.com/t5/Service/DM-GWPipeline-Gateway-TimeoutError/m-p/1029967

[Anonymous]

Hi @mwegener ,

the link is a solution for SQL Server DB Connection.

 the Incremental Refresh doesn't works for ODBC Connection with HANA because Folding Query is not available but only for HANA connector.