Refresh failed due to too high memory consumption

[FilipK]

I've got a dataset on my power bi workspace that is according to "Bravo for Power BI" 952MB big.

The workspace is linked to Power BI Embedded A2 tier (memory limit 5GB). It often appears that the dataset cannot be refreshed.

"More details: consumed memory 6147 MB, memory limit 4059 MB, database size before command execution 1060 MB."

My report uses incremental refresh.

What are possible root causes for the error?

[FilipK]

We've tried with a smaller dataset.

Here it is even worse. How can that happen?

More details: consumed memory 5270 MB, memory limit 5098 MB, database size before command execution 21 MB

[SivaMani]

@FilipK , It could be due to the transformations applied in Power Query or the setup of your incremental refresh settings.

1. Check the table transformations in Power Query and try to push them to the source
2. Check the incremental refresh period - https://learn.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-configure#define-policy
3. Refer this article for more details - https://learn.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-troubleshoot

[FilipK]

@SivaMani , thanks for quick response. I did all the checkings, but seems to be all good.

I don't understand, why the increase of SQL performance helps to overcome the issue. What is the relation between the memory error and sql performance. I don't get it.