Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Dpyr
Frequent Visitor

Scheduled refresh failing while refresh now succeeds

Hallo,

 

I have a refresh issue in Power BI service.

Scheduled refresh fails returning memory error:

Dpyr_1-1624344977166.png

 

Last refresh failed: Tue Jun 22 2021 01:18:13 GMT+0300 (Eastern European Summer Time)
There was an error when processing the data in the dataset. Hide details

Data source error:Memory error: Memory Allocation failure . Try simplifying or reducing the number of queries.
Cluster URI:WABI-WEST-EUROPE-B-PRIMARY-redirect.analysis.windows.net
Activity ID:a152c8b7-4707-4d89-8b56-bab2abaf0d30
Request ID:15e03d8e-1f22-4a59-bbdc-c7d4d6e1cd9f
Time:2021-06-21 22:18:13Z

 

Although, when I click on Refresh Now button, refresh completes in less than 20 minutes.

 

Here is the refresh history, last refresh was by scheduled refresh & previous by refresh now:

Dpyr_0-1624344953789.png

 

I checked the storage limit, from the manage personal storage of settings and it is much smaller than the limit:

Dpyr_2-1624345106395.png

 

Is there anything else which could cause a scheduled refresh fail?

1 ACCEPTED SOLUTION

Hi @Dpyr ,

 

Since this is the free version, I would suggest that you try again on a new report, but with only one query at a time.  That might help you with determining if it is one specific query you have.




Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!
Private message me for consulting or training needs.




View solution in original post

3 REPLIES 3
collinq
Super User
Super User

Hi @Dpyr ,

 

Does this issue happen every time or is it intermittent?  Is this a premium workspace?  Does this happen to only one report or many reports?




Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!
Private message me for consulting or training needs.




Dpyr
Frequent Visitor

Hallo @collinq 

 

Yes it is happening every time.

It is a free workspace and I have only this report published.

 

I tried deleting each column which doesn't need and make some of the queries steps in the database instead of power bi query editor.

I published again the report but it still fails to refresh, even if I click on refresh now. It keeps getting the same error, about the memory allocation.

Hi @Dpyr ,

 

Since this is the free version, I would suggest that you try again on a new report, but with only one query at a time.  That might help you with determining if it is one specific query you have.




Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!
Private message me for consulting or training needs.




Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors