Forum Discussion
Error: Query has exceeded available resource
Hi , I have created a matrix visual and I have connected my data using direct query mode and my data has around 5 million records.I have created around 10 measures which are required for the matrix ...
The error doesn't mention 1 million row limit, so is related to cost of operations in formula engine, after data cache has been returned from data source. Need to optimize your measures, this might be adjusting your measures so more work is done by your data source, rather than the formula engine. You will have to use DAX studio to look at server timings to find the problematic measures, then look at query plans and play around