Scheduled refresh

[MattiaAcc]

Hi everyone,

I published a report in PBI online and scheduled 8 planned refreshs per day. This error happens one time each 2/3 days and then if I force the refresh manually it works. Refresh failure details: We reached the end of the buffer.

The offline PBI desktop has no errors. If I try to refresh data I have any problem there. The database is a powerbi query generated by an online project management tool called Kanbanize.

Any of you know which problem is occuring?

Thanks a lot

[jaweher899]

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.

[Anonymous]

Sir, I don't think so making changes in the Power BI Desktop regarding the memory management can cause or affect the required changes while schedule refreshing the Report in Power BI Service.

[MattiaAcc]

About the first solution, I can't find the setting "Maximum allowed memory usage" inside the workbook setting: 

And this is what I see in the global section:

Which parameter should I change?

Thanks