Forum Discussion
Advocate IFailed 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.
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.
YadavagiriHi Anonymous
Thanks for your response and suggestion.
Have a clarification on below suggestion by you:
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.
"consider refreshing them in segments rather than all at once" - How this needs to be done? is this needs to be done manually refresh table by table? please advise?
Regards,
Yadavagiri
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.