Refreshed Failed

[mmills2018]

Hello, 

I keep getting the below error when refreshing my dataset. i have read several articles but I am having a hard time figuring out how to correct this. can someone please assist?

Refresh Failed - PPU - This operation was canceled because there wasn’t enough memory to finish

The scheduled refresh for a dataset in PPU (Premiunm per User) workspace is failing with a memory error:

Resource Governing: This operation was canceled because there wasn’t enough memory to finish running it. Either increase the memory of the Premium capacity where this dataset is hosted or reduce the memory footprint of your dataset by doing things like limiting the amount of imported data. More details: consumed memory 51399 MB, memory limit 51351 MB, database size before command execution 51048 MB. Learn more, see https://go.microsoft.com/fwlink/?linkid=2159753.

[v-easonf-msft]

Hi, @mmills2018 

According to the error message, this is caused by insufficient memory resources.

Are you allocating your PPU capacity to too much workspace? How big is the dataset for the report?

Also, notice to avoid multiple data refreshes on the report within the same time period.

Best Regards,
Community Support Team _ Eason