Forum Discussion

Dpyr's avatar
Dpyr
Frequent Visitor
5 years ago
Solved

Scheduled refresh failing while refresh now succeeds

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)...
Need Help
  • collinq's avatar
    collinq
    5 years ago

    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.

Dpyr's avatar
Dpyr
Frequent Visitor
5 years ago

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's avatar
collinq
Icon for Super User rankSuper User
5 years ago

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.