Semantic Model Refresh - Memory limit

p_da 

I would suggest you to checkout this article to understand the memory consumption for data refresh operation 

https://blog.crossjoin.co.uk/2023/04/30/measuring-memory-and-cpu-usage-in-power-bi-during-dataset-refresh/

I addition to the hackcrr suggestion, I would like to suggest one more approach, you can use enhanced refresh operation keep the commit mode as 'partialBatch', it can reduce the memory consumption.

https://blog.crossjoin.co.uk/2024/05/12/the-partialbatch-commit-mode-in-the-power-bi-enhanced-refresh-api/

Please read the complete blog before testing. 

Need a Power BI Consultation? Hire me on Upwork

Connect on LinkedIn

Did I answer your question? Mark my post as a solution! If I helped you, click on the Thumbs Up to give Kudos. Proud to be a Super User!