Forum Discussion

kevingauv's avatar
kevingauv
Icon for Advocate III rankAdvocate III
4 years ago

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...
Need Help
kevingauv's avatar
kevingauv
Icon for Advocate III rankAdvocate III
2 years ago

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.

pacifist's avatar
pacifist
Icon for Helper II rankHelper II
2 years ago

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).