Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
ChrisElu
Frequent Visitor

OData failing to refresh - Operation canceled because there wasn’t enough memory to finish it

I have a Power BI dataset connected to an OData source (Dynamics endpoint - crm4.dynamics.com). It was refreshing fine for a while, but suddenly stopped refreshing and is throwing the following error message.

"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. More details: consumed memory MB, memory limit MB, database size before command execution MB."

The workspace has a Embedded license and the default storage format is set to "Small dataset storage format"

Is anyone familiar with this error and how did you resolve it?

Thanks

 

1 ACCEPTED SOLUTION
v-tangjie-msft
Community Support
Community Support

Hi @ChrisElu ,

 

Please note the A1 SKU limit on dataset memory:

vtangjiemsft_0-1668045459397.png

 

Capacity and SKUs in Power BI embedded analytics - Power BI | Microsoft Docs

 

Refresh is a background operation that can occur when two conditions are met:

  • There is sufficient memory
  • The number of supported concurrent refreshes for the Premium capacity is not exceeded

When the conditions are not met, the refresh is queued until the conditions are favorable.

 

For a full refresh, recall that 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 becomes inactive and can be evicted.

 

For more information, please refer to: Optimize Microsoft Power BI Premium capacities - Power BI | Microsoft Docs

 

Please check if there is any remaining memory in the workspaces.

vtangjiemsft_1-1668045459239.png

 

 

 

Best regards,

Neeko Tang

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

View solution in original post

1 REPLY 1
v-tangjie-msft
Community Support
Community Support

Hi @ChrisElu ,

 

Please note the A1 SKU limit on dataset memory:

vtangjiemsft_0-1668045459397.png

 

Capacity and SKUs in Power BI embedded analytics - Power BI | Microsoft Docs

 

Refresh is a background operation that can occur when two conditions are met:

  • There is sufficient memory
  • The number of supported concurrent refreshes for the Premium capacity is not exceeded

When the conditions are not met, the refresh is queued until the conditions are favorable.

 

For a full refresh, recall that 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 becomes inactive and can be evicted.

 

For more information, please refer to: Optimize Microsoft Power BI Premium capacities - Power BI | Microsoft Docs

 

Please check if there is any remaining memory in the workspaces.

vtangjiemsft_1-1668045459239.png

 

 

 

Best regards,

Neeko Tang

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.