Incremental refresh failure

Hi  SimonT_HSO ,

Can you refresh tables one by one and check which one is causing that ?

You can increase query time out

https://community.powerbi.com/t5/Desktop/Query-Timeout-on-update/td-p/53459

Or See in Power Query to see if you can see the native query when you right-click on the last step.
If you can it should query fold (which will allow for incremental refreshing).
If no query folding then it cannot complete the incremental refresh.
Refer to:

Incremental refresh for datasets and real-time data in Power BI - Power BI | Microsoft Learn

This is the related document, you can view this content:

Chris Webb's BI Blog: Troubleshooting Power BI Timeouts, Part 1: The Two/Five Hour Import Refresh Limit (crossjoin.co.uk)

Power Bi Service Refresh - timeout expiration issu... - Microsoft Power BI Community

Timeout expired. The timeout period elapsed prior ... - Microsoft Power BI Community

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.