Forum Discussion
PowerBi Pro - Incremental refresh - Time out error at first upload
Hi all I configured incremental refresh on a report based on a transactions table with millions of records for which I want to: - Keep records of the last (full) year - Refresh data of the last 3...
Hi there
You can set the timeout feature on the query from your Oracle source.
Here is my blog post for SQL Server, but there will be similar features for Oracle: https://www.fourmoo.com/2020/02/26/ensuring-your-power-bi-incremental-refresh-does-not-timeout-when-using-a-sql-server-source/
You can set the timeout feature on the query from your Oracle source.
Here is my blog post for SQL Server, but there will be similar features for Oracle: https://www.fourmoo.com/2020/02/26/ensuring-your-power-bi-incremental-refresh-does-not-timeout-when-using-a-sql-server-source/
Hi GilbertQ
Thank you for your answer. I already tried this option, setting it to 3600 (maybe too much 🙂 ). I'm trying again with a lower value (180 minutes) to see what happens. Please note that, based on the checks we made on the database side, the query execution in Oracle ends up within the two hours but the data transfer through the gateway takes longer.
If this test fails, I will manually partition the transactions table in smaller ones based on that and then merge them with union command, disabling the refresh for the older ones. I applied this workaround in other reports but I really hoped that incremental refresh could have helped.
Best regards,
Francesca
- Hi there
It could well be that the transfer of the data is taking too long and that is causing the timeout?
