My dataset refreshes fine when in PowerBI desktop (10min), but after publishing it in a Premium workspace and refreshing (no other refreshes goiing on) it results in the error below:
Fout in de gegevensbron: 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. Learn more, see https://go.microsoft.com/fwlink/?linkid=2159753.
URI cluster: WABI-NORTH-EUROPE-K-PRIMARY-redirect.analysis.windows.net
Tijd: 2022-09-01 09:52:19Z
Experimenting: I've published the dataset to an workspace PRO (insteadof Premium) and then it refreshes successfully, but taking more then one hour.
Because we do not want to go back to Pro and also do not want to go higher then Capacity P1, can anyone tell how to reduce memory (while is is much smaller then 25Gb)?
Hi @DouweAtAlfa ,
I investigated your error through this doc:
Troubleshoot XMLA endpoint connectivity in Power BI - Power BI | Microsoft Docs
it says some situation may cause the error as yours, eg:
Through these options maybe can avoid error:
Community Support Team Selina zhu