Scheduled refresh

The error message "We reached the end of the buffer" in Power BI typically indicates that the size of the data being refreshed exceeds the maximum capacity of the buffer, which causes the refresh to fail. This error can occur when there is a large amount of data being refreshed, or when the data source is slow to respond during the refresh process.

One potential solution is to increase the size of the buffer in the Power BI settings to allow for larger amounts of data to be refreshed. To do this, go to the "Options" tab in the Power BI Desktop and select "Data Load". Under "Workbook Settings", adjust the "Maximum allowed memory usage" to a higher value.

Another solution is to optimize the data source or reduce the amount of data being refreshed. You may want to consider filtering the data to reduce the number of rows being refreshed, or optimizing the database queries to improve the speed of the refresh process.

You may also want to check the Power BI Service logs to see if there are any other error messages or warnings that could provide more insight into the issue. You can access the logs by going to the "Settings" menu in the Power BI Service and selecting "Admin portal", then navigating to the "Audit logs" or "Diagnostic logs" section.