Forum Discussion
Trouble with refreshing and publishing reports
Hi all,
We're experiencing problems with refreshing our datasets in Power BI service since last Tuesday (22-11-2021).
Reports with big datasets that normally take about 30 minutes to refresh suddenly won't refresh at all, and it seems like they are just stuck on loading. Then after a long while we get the following error:
Verwerkingsfout: There's not enough memory to complete this operation. Please try again later when there may be more memory available.
URI cluster: WABI-NORTH-EUROPE-L-PRIMARY-redirect.analysis.windows.net
Activiteits-id: 12e7c9e5-6381-4f71-b86c-68db75c46e97
Aanvraag-id: 00f7140c-d631-4727-874c-849ce0848162
Tijd: 2021-11-25 08:01:20Z
We have no idea what causes this problem all of the sudden, the error message doesn't really provide any further insight in this issue.
In the meantime we tried to work-around the issue by refreshing the report in desktop and then publish and overwrite the current report in service. The refresh loads without any trouble for about 10 minutes, but then when I try to publish/overwrite the current dataset in service it gives another error.
Does anyone know how we can further investigate this error, what it includes, and maybe how to solve this issue?
(we are prepared to upscale in memory if it's necessary, we just don't know how)
Thanks in advance!
Hi, StanTheMan
There are many reasons for insufficient refresh memory. First, I suggest you optimize the report.
1. Streamlined model. It can be designed to avoid loading unnecessary data by removing columns, removing rows (especially historic data) or by loading summarized data (at the expense of loading detailed data). Dramatic size reduction can be achieved by removing high cardinality columns (especially text columns) which do not store or compress very efficiently.
2. Reduce the number of visual objects in the report.
3. There may be opportunity to tune DAX expressions for measures and RLS rules, perhaps rewriting logic to avoid expensive formulas.
4. Incremental refresh can dramatically reduce refresh time and conserve memory and CPU. The incremental refresh can also be configured to remove historic data keeping model sizes trim.
5. Model query performance can be improved by configuring single direction relationships unless there is a compelling reason to allow bi-directional filtering. Consider also using the CROSSFILTER function instead of bi-directional filtering.
At the same time, it is recommended that you reasonably arrange the refresh time to reduce the refresh of other reports.
Please refer to the following documents to see if they are helpful.
Optimize Microsoft Power BI Premium capacities - Power BI | Microsoft Docs
Incremental refresh for datasets in Power BI - Power BI | Microsoft Docs
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
v-zhangtiCommunity Support
Hi, StanTheMan
There are many reasons for insufficient refresh memory. First, I suggest you optimize the report.
1. Streamlined model. It can be designed to avoid loading unnecessary data by removing columns, removing rows (especially historic data) or by loading summarized data (at the expense of loading detailed data). Dramatic size reduction can be achieved by removing high cardinality columns (especially text columns) which do not store or compress very efficiently.
2. Reduce the number of visual objects in the report.
3. There may be opportunity to tune DAX expressions for measures and RLS rules, perhaps rewriting logic to avoid expensive formulas.
4. Incremental refresh can dramatically reduce refresh time and conserve memory and CPU. The incremental refresh can also be configured to remove historic data keeping model sizes trim.
5. Model query performance can be improved by configuring single direction relationships unless there is a compelling reason to allow bi-directional filtering. Consider also using the CROSSFILTER function instead of bi-directional filtering.
At the same time, it is recommended that you reasonably arrange the refresh time to reduce the refresh of other reports.
Please refer to the following documents to see if they are helpful.
Optimize Microsoft Power BI Premium capacities - Power BI | Microsoft Docs
Incremental refresh for datasets in Power BI - Power BI | Microsoft Docs
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.