cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
StanTheMan
Frequent Visitor

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!

1 ACCEPTED SOLUTION
v-zhangti
Community Support
Community 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.

View solution in original post

1 REPLY 1
v-zhangti
Community Support
Community 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.

View solution in original post

Helpful resources

Announcements
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!