Forum Discussion
Error in schedule refresh
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."
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
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
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.
4 Replies
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
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.
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
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
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.
