Matrix errors - Resources Exceeded - Power BI Service

[gpielow]

Pulling a very small dataset, can't even get half a month and now the Matrix gives this error.

It's ok from Desktop but unfortunately not in the service.

Resources Exceeded
The query has exceeded the available resources. Try filtering to decrease the amount of data requested.

Has anyone else been experiencing this.  This is new for me.  We are a Power BI pro shop

Thank you

[v-karpurapud]

Hi @gpielow 

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[v-karpurapud]

Hi @gpielow 

Could you please confirm if your query have been resolved the solution provided by @d_m_LNK & @Deku ? If they have, kindly mark the helpful response and accept it as the solution. This will assist other community members in resolving similar issues more efficiently.

Thank you

[d_m_LNK · Accepted solution]

Things to look for in your measures would be:
1. Using Filter with a large table -- this loads the whole table then filters it

2. Using Summarize inside a measure also can cause a lot of excess data to be loaded when not needed and optimizing it could help

This Video by SQLBI is a good resource for some potentialy issues that might be happening: Filter columns, not tables, in DAX - YouTube

Optimizing Summarize SQLBI: Optimizing SUMMARIZE by using ADDCOLUMNS - Unplugged #40

[Deku]

It will be because one of your measures is creating a large data cache. Can't say more without more context. Would need to see data model and measures