Forum Discussion

ImranAslamSSW's avatar
ImranAslamSSW
Frequent Visitor
4 years ago
Solved

Refresh Fail

Hi All, I facing the below error on my schedule refresh. Data source errorResource Governing: This operation was canceled because there wasn’t enough memory to finish running it. Either increase th...
Dataflow
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi ImranAslamSSW ,

    When the data refresh commences but fails to complete, it can be due to several reasons:

    • Insufficient memory, even if there is only one model in the Premium capacity, i.e. the model size is very large.
    • Non-capacity reasons, including datasource system disconnection, invalid permissions or gateway error.

    Capacity Admins (and Power BI service administrators) can monitor the Refresh Failures due to out of Memory metric.

     

    When additional Premium capacity is required, there are two options:

    • Scale-up an existing Premium capacity
    • Add a new Premium capacity

    More details: Optimizing Premium capacities 

     

    If you want to upgrade the capacity to P2. Power BI admins and global administrators can change Power BI Premium capacity. Capacity admins who are not a Power BI admin or global administrator don't have this option.

    1. Select the capacity name you want to change the size of.

    2. Select Change size. You can see.

    3. On the Change size screen, upgrade or downgrade your capacity as appropriate.

    More details: Change capacity size 

     

    Relevant Document： Configure workloads in a Premium capacity 

     

    Best Regards

    Community Support Team _ Polly

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi ImranAslamSSW ,

When the data refresh commences but fails to complete, it can be due to several reasons:

  • Insufficient memory, even if there is only one model in the Premium capacity, i.e. the model size is very large.
  • Non-capacity reasons, including datasource system disconnection, invalid permissions or gateway error.

Capacity Admins (and Power BI service administrators) can monitor the Refresh Failures due to out of Memory metric.

 

When additional Premium capacity is required, there are two options:

  • Scale-up an existing Premium capacity
  • Add a new Premium capacity

More details: Optimizing Premium capacities 

 

If you want to upgrade the capacity to P2. Power BI admins and global administrators can change Power BI Premium capacity. Capacity admins who are not a Power BI admin or global administrator don't have this option.

  1. Select the capacity name you want to change the size of.

  2. Select Change size. You can see.

  3. On the Change size screen, upgrade or downgrade your capacity as appropriate.

More details: Change capacity size 

 

Relevant Document： Configure workloads in a Premium capacity 

 

Best Regards

Community Support Team _ Polly

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.