Forum Discussion
Incremental refresh failure
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
2 Replies
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:
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.
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
