Forum Discussion
Matrix errors - Resources Exceeded - Power BI Service
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
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