Forum Discussion
Analyze in Excel causing Premium Gen2 to Auto Scale-Up?
Hi! We are using Premium Gen2 P1 with Auto Scale-Up enabled since last November. Since then, Scale-Up process occurred every week. 1 to 5 times a week, sometime up to 4 more CPU. We are tryi...
Hi, on our side, we never found a real solution, unfortunatly.
We found that an AnalyseInExcel based on a Dataset that use a Direct QUery on another Dataset increase the problem a lot.
We try to limit the use of AnalyseInExcel feature for the user by coaching them.
Build Permission are given with precaution.
We discourage the use of DirectQuery between Dataset.
Sorry to not have another good solution.
Hi, thank you, that's was helpful and basically on par with our approach at the moment. Analyze In Excel is one terrible functionality, probably there only for those dinosaurs as well as to increase the cost (=profit for MS).