Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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)?
kind regards
Douwe
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.