Scheduled refresh failing while refresh now succeeds

[Dpyr]

Hallo,

I have a refresh issue in Power BI service.

Scheduled refresh fails returning memory error:

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: I checked the storage limit, from the manage personal storage of settings and it is much smaller than the limit: Is there anything else which could cause a scheduled refresh fail?

[collinq]

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?

[Dpyr]

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.

[collinq · 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.