Forum Discussion
Helper IIThere's not enough memory to complete this operation.
Memorable MemberHi shubhamamilkant ,
I was dealing with similar problem some time ago. You said that refreshing of report in desktop is without any problems. How strong is your desktop?
I have found out, that PQ actually consumes quite a lot of memory in total. Basically it cummulates memory from all those steps you have, so even a small file with 10MB, can eventually require 1GB for refresh.
I think unless you have Premium Capacity, you can't really observe how much CPU/RAM you consume.
Best think you can do is to ensure, you don't have any extra steps in your query so your query is optimized. Also try to avoid refresh all your reports at the same time.
Let me know, if you solved the problem.
shubhamamilkantIs there a better way to schedule different reports at different times, than doing it manually/selecting a scheduled time for each dataset.
Like refreshing a report every few hrs but only if other datasets are not running already.
- Icey
Community Support
Hi shubhamamilkant ,
To my knowledge, this is not supported currently. It is needed to manually change the scheduled refresh times.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Migasuke
Hi shubhamamilkant ,
You might consider to use REST API. I havent really used it yet, but there are some cool possibilities. You can refresh your datasets, you can get refresh history etc. So maybe that would work for you.
Check more here:
https://docs.microsoft.com/en-us/rest/api/power-bi/datasets/get-refresh-schedule- shubhamamilkant
Thank you for the response. is it possible to use Airflow with REST API to maintain all the dataflows?
