Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to Solution.
Hi @ChrisElu ,
Please note the A1 SKU limit on dataset memory:
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:
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.
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.
Hi @ChrisElu ,
Please note the A1 SKU limit on dataset memory:
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:
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.
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.
User | Count |
---|---|
126 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |