Forum Discussion
Query keeps exceeding available resources when published - How can i optimise?
Hi derekli1700 ,
Thank you for reaching out to the Microsoft fabric community forum.
Using DAX Studio, Yugandhar identified that the dynamic customer ranking per site was significantly increasing query load, especially given the large volume of data and multiple Excel sources.
A few things you might want to try: If your customer-site combinations don’t change too often, calculating the ranks during data load can really help reduce the pressure on your visuals. Creating a separate summary table (like customer-site-month) can make your visuals much faster and easier to manage. If you can reduce how many times you're calculating the same measure inside your ranking logic, that can go a long way. And while the Top N filter pane doesn’t work per site, it might still be useful in other parts of your report.
Best Regards,
Harshitha.
Hi derekli1700 both assumptions are correct. Is there a way you can reduce your data source volume? Other thing you can try is using the Top N filters from the Filters Pane. Not as great as measures but usually run faster than them.
Hey - for top n filter pane regarding customers, it only shows the rows for the top n customers for every site instead of that specific site.
i.e if customer 1,4,6,3,7 were the customers of the highest value in the whole dataset, then the top n filter pane would only show rows for customer 1,4,6,3,7 under each site purely - meaning some rows under stores would be blank as they might not have interacted with those selected customers.