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
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.