Failed to save modifications to the server. Error returned: - Solution required

Hi Yadavagiri 

Failed to save changes to the server. Error returned: 'Out of memory...' Indicates that the operation you attempted to perform exceeded the available memory resources.

 If you're using Power BI Pro, consider moving to Power BI Premium or Premium Per User (PPU) for higher memory limits.

The memory limit is determined by the SKU of the Premium capacity.

If your dataset is divided across multiple CSV files and folders, consider refreshing them in segments rather than all at once. This approach can help manage memory usage more effectively.

Regards,

Nono Chen

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

Hi Yadavagiri 

If you're using Power BI Pro or Premium, you can take advantage of the Incremental Refresh feature.

This allows you to refresh only the data that has changed or been added since the last refresh, rather than the entire dataset.

Understand and optimize dataflows refresh - Power BI | Microsoft Learn

For a more automated approach, you can use the Power BI REST API to programmatically refresh segments of your dataset. 

Enhanced refresh with the Power BI REST API - Power BI | Microsoft Learn

If Incremental Refresh is not an option, you can consider refreshing specific tables manually.

Regards,

Nono Chen

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