Forum Discussion
Solved
Schedule refresh failed - exception raised by IData Reader
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:...
Hi SueM
Power BI refresh timeout failures are usually due to the dataset being too large or too complex. Here are some solutions:
- Reduce Dataset Size: Try to reduce the size or complexity of the dataset. This can be achieved by removing unnecessary data or optimizing queries.
- Increase Refresh Time: For Power BI Premium users, the refresh time can be increased from the default two hours to five hours.
- Split the Dataset: Divide a large dataset into multiple smaller datasets and refresh them separately.
- Check Gateway Version: Ensure that you are using the latest version of the gateway and that it is configured correctly.
- 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.
- Reduce Dataset Size: Try to reduce the size or complexity of the dataset. This can be achieved by removing unnecessary data or optimizing queries.
Thank you. I made changes to the filter on the GI's and the refresh is working now.
Thank you. I made changes to the filter on the GI's and the refresh is working now.