Problens with a large matrix

[AgroBeloni]

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?

[Anonymous]

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.

[lbendlin]

please provide more details. 

- data source

- connection type

- Power BI environment (shared or premium)

- if premium - what SKU ?