Error in schedule refresh

[anmolmalviya05]

Hi Everyone, Hope you are doing good.

I have a report which i have published into two workspace, one is pro and other is premium.

it's getting refreshed properly in the pro workspace, but it's giving below error in premium workspace.

I have checked all the settings and parameter, everything is same.

"This operation was canceled because there wasn't enough memory to finish running it. Either reduce the memory footprint of your dataset by 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 1731 MB, memory limit 1723 MB, database size before command execution 1348 MB."

[SaiTejaTalasila · Accepted solution]

Hi @anmolmalviya05 ,

Pull the metrics from your capacity metrics report data model and do some analysis.

You can refer chris web's articles for analysis 

https://blog.crossjoin.co.uk/2024/06/23/power-bi-semantic-model-memory-errors-part-4-the-query-memor...

If you are unable to find any details you can open a ticket with Microsoft support.

I hope it will be helpful.

Thanks,

Sai Teja 

[Anonymous · Accepted solution]

Hi @anmolmalviya05 ,

Based on the description, the max memory per query for A1 is 1 GB. Try to reduce the data size by filtering data.

Besides, you can also view the following document to learn more information.

What is Power BI Premium? - Power BI | Microsoft Learn

Solved: Power BI failed refresh- Not enough memory - Microsoft Fabric Community

Troubleshoot refresh scenarios - Power BI | Microsoft Learn

Solved: Pro license - Max Dataset size - Microsoft Fabric Community

Best Regards,

Wisdom Wu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[SaiTejaTalasila · Accepted solution]

Hi @anmolmalviya05 ,

Pull the metrics from your capacity metrics report data model and do some analysis.

You can refer chris web's articles for analysis 

https://blog.crossjoin.co.uk/2024/06/23/power-bi-semantic-model-memory-errors-part-4-the-query-memor...

If you are unable to find any details you can open a ticket with Microsoft support.

I hope it will be helpful.

Thanks,

Sai Teja 

[pallavi_r]

Hi @anmolmalviya05 ,

This is very strange that it works in Pro and failing in Premium. There are other datasets in the premium that might be causing the overhead and memory issue. Please check once in the capacity metrics.

I have received this error in situation similar to yours once due to a calculated column that was taking memory during refresh. Please check if you have any calculated column or a measure. Try refreshing only the dataset without any measure and calculated columns. 

Thanks,

Pallavi

[anmolmalviya05]

Hi @pallavi_r, I'm also shocked by  seeing the error, because there are more than 10 reports and dataset in both the workspace, and everything is same (Dataset behind the reports). I'm still confused why it's getting refreshed succesfully in Pro workspace, while giving error in premium. We are using A1 capacity.