0

I am getting timeout error when I schedule data refresh, but I can refresh data manually. Data refresh unattended account has enough permissions for database server and tables. Is there any idea why I am getting this error?

The operation has timed out

enter image description here

0

Finally solved.

This issue is caused by a change to the design of the product in SharePoint 2016 that limits a single PowerPivot data source to a refresh duration of 100 seconds (or 1:40). Note that this can also be caused by slow or underperforming data sources if you think your data should be refreshing in under 100 seconds. If you are pulling a small amount or data from a complex data source that takes a long time to query, you may consider alternative workarounds as increasing the timeout may not be the best option.

enter image description here

Here is more info.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.