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 ,
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 ,
I hope the information provided above assists you in resolving the issue. If you have any additional questions or concerns, please do not hesitate to contact us. We are here to support you and will be happy to help with any further assistance you may need.
Regards,
Harshitha.