Forum Discussion

kevingauv's avatar
kevingauv
Advocate 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
v-kkf-msft's avatar
v-kkf-msft
Community Support
4 years ago

Hi kevingauv ,

 

Please use "Analyze in Excel", then open Task Manager > Performance, check how much CPU and memory are consuming. If the capacity limit is often exceeded, then I think expanding the capacity size is a appropriate option.

 

If your problem is still not solved, I would like you to create a support ticket.

How to create a support ticket in Power BI 

 

Best Regards,
Winniz

kevingauv's avatar
kevingauv
Advocate III
4 years ago

Hi, problem still occurs.

 

We will open a ticket shortly

  • pacifist's avatar
    pacifist
    Helper II
    2 years ago

    Hi, sorry to revive the old post. How did you resolve it? We are experiencing lots of XMLA Read Operations peaking up our capacitites and I wonder what's guidelines around it. Thank you

    • kevingauv's avatar
      kevingauv
      Advocate 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
        Helper 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).