The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I'm receiving the following error and need you to localizing the root cause:
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 1846 MB, memory limit 1846 MB, database size before command execution 1225 MB.
I'm running on A1 Gen 2 capacity with only one dataset on it. This dataset is according to Bravo: 901 MB. According https://app.powerbi.com/ -> Report Settings -> Large dataset storage format : 670 MB (I'm not using that format, but here at least I found the size).
For A1 has a max memory of 3GB the problem should not occur. I read that the required memory is around 2.5x of your dataset size which I would conclude is the case. The metrics in the Azure resource doesn't help. The CPU load is only like 15% max and the overload metric is looking usual.
How would you approach the issue?
User | Count |
---|---|
42 | |
16 | |
13 | |
11 | |
9 |
User | Count |
---|---|
51 | |
31 | |
23 | |
18 | |
15 |