Refresh failed due to not enough memory

[Fernandostn]

I'm trying to update a 2GB report in Power BI Services, but the following error message appears:

Resource Governance:

This operation was canceled because there wasn't enough memory to finish running it. Either reduce the memory footprint of your dataset by doing things such as limiting the amount of imported data, or if using Power BI Premium, increase the memory of the Premium capacity where this dataset is hosted.

More details: consumed memory 4408 MB, memory limit 4408 MB, database size before command execution 711 MB.

We are using Fabric Capacity

I saw on the forum that to solve this problem I need to scale up the capacity, how could I do that?

Thank you.

[v-aatheeque]

Hi @Fernandostn 

Following up to confirm if the earlier responses addressed your query. If not, please share your questions and we’ll assist further.

[v-aatheeque]

Hi @Fernandostn 

Have you had a chance to look through the responses shared earlier? If anything is still unclear, we’ll be happy to provide additional support.

[cengizhanarslan]

That means the refresh operation is reaching the per-operation memory cap of your current Fabric SKU. Even though your dataset size is 711 MB, refresh can temporarily require several times more memory due to:

• VertiPaq compression rebuild

• Dictionary creation

• Relationship reprocessing

• Calculated columns / complex transformations

[djurecic · Accepted solution]

Hi @Fernandostn ,

 You need to be a capacity admin to do this and here are the instructions:

https://learn.microsoft.com/en-us/fabric/enterprise/scale-capacity

Once you are logged in to the Azure Portal, select the capacity, then select Scale > Change Size. Select the size you want to change to, the select "Resize"

Edit: As @cengizhanarslan mentions, an alternative to increasing your capacity is to reduce the size of your model.