Problem

The following error occurs when refreshing your dataset:

Resource Governing: This operation was canceled because there wasn’t enough memory to finish running it. Either increase the memory of the Premium capacity where this dataset is hosted or reduce the memory footprint of your dataset by doing things like limiting the amount of imported data.

Solutions

For a full dataset refresh in a Premium capacity, at least double the current dataset memory size is required. If sufficient memory is not available, then the refresh cannot commence until model eviction frees up memory - this means delays until one or more datasets become inactive and can be evicted.

So, as you are getting the above error message, you must consider trying out the following methods to solve the problem:

• Decrease the dataset size by limiting data history.
• Try to change the schedule refresh timings and frequency (in case you have multiple datasets scheduled to refresh under the same capacity simultaneously).
• If you have other Premium capacities in your tenant, assign the content to a different capacity (scale out the capacity). This would ensure load balancing in the capacities and ensure enough memory is present to carry out a specific task simultaneously.
• Scale up the capacity. (Lastly, you could consider going for higher capacity if it meets your business requirements). For example, upgrading to P2 capacity if you are currently using P1.

Here are a few optimizing techniques:

1. Optimization guide for Power BI: https://docs.microsoft.com/en-us/power-bi/guidance/power-bi-optimization
2. Data reduction techniques for Import models: https://docs.microsoft.com/en-us/power-bi/guidance/import-modeling-data-reduction
3. Star schema Design and its relevance with developing Power BI Models: https://docs.microsoft.com/en-us/power-bi/guidance/star-schema
4. Direct Query Model Design in Power BI: https://docs.microsoft.com/en-us/power-bi/guidance/directquery-model-guidance
5. Composite Model Guidance in Power BI: https://docs.microsoft.com/en-us/power-bi/guidance/composite-model-guidance

If you have any other queries regarding the issue, please let us know your feasibility for a remote share session to discuss the issue.