Gateway

[vshiva]

I have hundreds of datasets being scheduled refresh in Power BI Gateway Server. Is there any option in the Power BI service to know the below metrics

1) How many datasets are being refreshed at a certain point of time? (Say between 6 AM and 8 AM)

2) Which are all the datasets that are being refreshed at a certain point of time?

Kindly help me with this.

[Anonymous · Accepted solution]

@vshiva There are a ton of metrics you can pull from the Office 365 audit logs. Check there to see if any of those metrics produce the results you need.

[vshiva]

Thank you so much @Anonymous.! After digging through the logs completely, we are able to find the list of users scheduling the refreshes at various timings.! This is the info we were looking for.! Thanks a ton.! 🙂

We need one final information to complete our solution. This info is on the size of the dataset being refreshed. This information is not available in the Logs.! Could you please shed some light on this, if you have some information on the same.

Thanks

[vshiva]

@Anonymous: Thanks for your response. We are unable to get these metrics from O365 logs. I would like to reiterate the problem we are facing here.

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:

• 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?