Forum Discussion
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.
The query has exceeded the available resources. Try filtering to decrease the amount of data requested.
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
4 Replies
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
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 #40Hi 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.
