Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
AgroBeloni
New Member

Problens with a large matrix

Hi!

 

My name is Arthur and I'm facing a problem with a matrix wich I can't solve yet. 

 

The database have about 10M lines and all of them must be consider by the caculations. When I open my dashboard all charts works ok, but the matrix shows the following error and won't open. 

 

Mais detalhes: Resource Governing: This query uses more memory than the configured limit. The query — or calculations referenced by it — might be too memory-intensive to run. Either reach out to your Analysis Services server administrator to increase the per-query memory limit or optimize the query so it consumes less memory. More details: consumed memory 1024 MB, memory limit 1024 MB.
ID da atividade: eec0384f-bbe0-4fb4-855f-f14d66068283
ID de correlação: 0faf2618-e9f6-f392-a630-24d96a076fb1
Solicitar ID: beeb2dea-4e4c-cd78-ef26-270f8a0d78da
Hora: Wed Aug 03 2022 12:41:12 GMT-0300 (GMT-03:00)
Versão do serviço: 13.0.18756.45
Versão do Cliente: 2207.4.12439-train
Cluster URI: https://wabi-brazil-south-redirect.analysis.windows.net/

 

How can I increase this limit of memory?

01.png02.png

2 REPLIES 2
v-binbinyu-msft
Community Support
Community Support

Hi @AgroBeloni ,

Shared Capacity: the dataset has 1G  limits.

For more details, you can read related document:Manage data storage in your workspaces - Power BI | Microsoft Docs

 

Premium Capacity: different sku has different limits

vbinbinyumsft_0-1661146876656.png

For more details, you can read related document:  What is Microsoft Power BI Premium? - Power BI | Microsoft Docs , What is Power BI Premium Gen2? - Power BI | Microsoft Docs

 

Best regards,
Community Support Team_ Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

 

lbendlin
Super User
Super User

please provide more details. 

- data source

- connection type

- Power BI environment (shared or premium)

- if premium - what SKU ?

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors