Forum Discussion

vshiva's avatar
vshiva
Frequent Visitor
7 years ago

Enterprise Gateway

Dear Team,

 

Context: I am maintaining a Power BI Enterprise Gateway service in a centralized server. It has many data sources and BI developers develop the Reports. The scheduled refreshes for these reports are being scheduled directly by BI developers.

 

Issue: My CPU memory usage is shooting up more than 80% between 6 AM and 8 AM almost every day.

 

Possible Solutions considered:

  • Increase the CPU configuration – Our current CPU has 64 GB RAM and we believe, all other configuration is also sufficient. So, as of now, improving the infrastructure is not the desirable solution for us.
  • Make the scheduled Refreshes Staggered – But I do not know what reports and how many reports are being refreshed between 6 AM and 8 AM.

 

Kindly let us know if there are any other possible alternative solution which we missed.

 

Requirement: We believe if we get to know the information on “Which reports and how many are being refreshed between 6 AM and 8 AM”, we might be able to improve the CPU performance. Request you to kindly let us know the possibility of getting this information. If possible, where should we look for this information?

Need Help

9 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    The Power BI gateway does indeed use a lot of RAM.  The mashup engine has to hold the data in memory.  It reaching 80% isn't necessary a concern, it could be related to the size of the data refreshes themselves.

  • v-frfei-msft's avatar
    v-frfei-msft
    Community Support
    7 years ago

    Hi vshiva,

     

    Based on my research, it is not possbile for us to get the information of how many datasets are being refreshed during a period.
    Maybe you can suggest the owner of datasets to configure the refresh time to a free time to reduce pressure of your CPU memory usage. 

     

    Regards,

    Frank

    • vshiva's avatar
      vshiva
      Frequent Visitor
      7 years ago

      Thanks v-frfei-msft and Anonymous for your valuable inputs.! We are exploring the possibility of wroking with the developers directly.!

       

      We are also trying to see whether Audit Logs or Event Logs will be somewhat helpful for us.! Request you to kindly shed some light on this, if you have some experience on the same.