Incremental refresh failure

[SimonT_HSO]

Hi

I am using the incremetal refresh for the first time.  Whilst the parameter filtering and policy settings were fine the refresh (both manual and scheduled) failed with the follwoing error:

Timeout expired. The timeout period elapsed prior to completion of the operation.. The exception was raised by the IDbCommand interface.

My source data is D365 F&O.

Any help gratefully recieved

[Anonymous]

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 Li...

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.

[SimonT_HSO]

Hi @Anonymous 

I had already found the probelm table and changed the timeout.  I don't see native query as I am using an OData connectioon to D365 F&O.  Does this mean incremental refresh won't work?

Regards

Simon