cancel
Showing results for 
Search instead for 
Did you mean: 
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
August 2022 update 768x460.jpg

Check it Out!

Click here to learn more about the August 2022 updates!

August 1 episode 9_no_dates 768x460.jpg

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Top Solution Authors