Increase timeout of Query with SAP HANA

[vmakhija]

Hello

I am using SAP HANA db for my Power BI report.

I have a query which is actually doing a UNION (append queries) of other 4 queries. Each of these 4 queries can take 3-4 hours to run.

So with Append queries, the main query takes around 14-15 hours to complete.

However, it seems that with Premium workspace, the max timeout for a query is 5 hours, so my dataset refresh times out due to this.

Any idea if this behavior can be changed? I need to make this work and run the refresh on Service successfully.

I can do the manual refresh fine on Power BI desktop.

Regards

[v-lili6-msft]

hi, @vmakhija 

If you could try to use Incremental refresh in Power BI Premium

https://docs.microsoft.com/en-us/power-bi/service-premium-incremental-refresh

Incremental refresh enables very large datasets in the Power BI Premium service with the following benefits:

• Refreshes are faster - Only data that has changed needs to be refreshed. For example, refresh only the last five days of a ten-year dataset.

• Refreshes are more reliable - It's no longer necessary to maintain long-running connections to volatile source systems.

• Resource consumption is reduced - Less data to refresh reduces overall consumption of memory and other resources.

or optimize your data model

https://docs.microsoft.com/en-us/power-bi/power-bi-reports-performance

http://blog.pragmaticworks.com/power-bi-performance-tips-and-techniques

Best Regards,

Lin