Forum Discussion
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?
2 Replies
please provide more details.
- data source
- connection type
- Power BI environment (shared or premium)
- if premium - what SKU ?
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
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.
