Schedule refresh failed - exception raised by IData Reader

[SueM]

Hi

I have a report which is based on a generic inquiry in Acumatica. This report refreshes once daily on a scheduled refresh, but recently the refresh has failed. giving the following error message: 

Timeout expired. The timeout period elapsed prior to completion of the operation.. The exception was raised by the IDataReader interface. Please review the error message and provider documentation for further information and corrective action. 

It failed once then the next day was sucessful then after that the refresh failed.

There have been no changes to the generic inquiry.

Any assistance would be greatly appreciated.

Many thanks.

[v-jialongy-msft · Accepted solution]

Hi @SueM 

Power BI refresh timeout failures are usually due to the dataset being too large or too complex. Here are some solutions:

1. Reduce Dataset Size: Try to reduce the size or complexity of the dataset. This can be achieved by removing unnecessary data or optimizing queries.
   
2. Increase Refresh Time: For Power BI Premium users, the refresh time can be increased from the default two hours to five hours.
   
   
3. Split the Dataset: Divide a large dataset into multiple smaller datasets and refresh them separately.
   
   
4. Check Gateway Version: Ensure that you are using the latest version of the gateway and that it is configured correctly.
   
   
5. Optimize Data Model: Simplify the data model to reduce computation and data processing time.

Troubleshoot refresh scenarios - Power BI | Microsoft Learn

Best Regards,

Jayleny

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

[SueM · Accepted solution]

Thank you. I made changes to the filter on the GI's and the refresh is working now.

[v-jialongy-msft · Accepted solution]

Hi @SueM 

Power BI refresh timeout failures are usually due to the dataset being too large or too complex. Here are some solutions:

1. Reduce Dataset Size: Try to reduce the size or complexity of the dataset. This can be achieved by removing unnecessary data or optimizing queries.
   
2. Increase Refresh Time: For Power BI Premium users, the refresh time can be increased from the default two hours to five hours.
   
   
3. Split the Dataset: Divide a large dataset into multiple smaller datasets and refresh them separately.
   
   
4. Check Gateway Version: Ensure that you are using the latest version of the gateway and that it is configured correctly.
   
   
5. Optimize Data Model: Simplify the data model to reduce computation and data processing time.

Troubleshoot refresh scenarios - Power BI | Microsoft Learn

Best Regards,

Jayleny

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

[lbendlin]

Please note that Power BI has a hard 5 hour limit. Your data source may have a lower limit.

Refactor your process to finish well before any of these limits hit.