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 Activiteits-id: befafc18-ef61-4079-a668-ea4c469ad407 Aanvraag-id: 278e0ebe-0564-78c2-debd-cc650d67c76c 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)?