Forum Discussion
Solved
Matrix errors - Resources Exceeded - Power BI Service
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 ...
Things to look for in your measures would be:
1. Using Filter with a large table -- this loads the whole table then filters it2. 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
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