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.