Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.