How to track and monitor report performance aka report load time?

[tondeli]

How do you fellow admins track report and data model performance?

I am administering a power bi service and I am always asked how some of the reports are running slow. I make some adjustments and it seems that reports are performing better. How can I be sure that my adjustments are giving the desired result?

So, I need to track and monitor reports and data set performance -how fast they load up (both import and direct query). But where I can find this information? Is this possible in worksheet level? I already have O365 audit logs but that does not include any performance information. Currently I am trying to read information from PBI API but I have not found information that I need.

Any advice?

[SaiTejaTalasila]

Hi @tondeli ,

If you have a premium capacity in that case you can use fabric metrics app.If no you can use performance analyser(in power bi desktop), check data quality of model using vartpaq analyser(dax studio),SQL profiler(SSMS),You can use tabular editor to identify unused columns.

You can load test your application it's possible with power shell.

I have seen people using the mentioned tools or methods to check/test and improve performance.

Thanks,

Sai Teja 

[v-eachen-msft]

Hi @tondeli ,

You could download the pbix file and use Performance Analyzer.

Or you could come up a new idea here to improve Power BI and make this feature coming sooner.

[tondeli]

My "problem" is that in our company we have several PBI developers and I can not track every report by myself. Luckily we have clear development guide that includes documentation template and a report based on Performance Analyzer. We also review every solution and accept them to be moved to production.

My goal is to find reports that are used often and are performing poorly. Reports with high usage and low performance will need attention and future development.

I can track following report performance indicators with audit logs and gateway logs

• usage per report
• import data set refresh times

As per @v-eachen-msft , I assume that you really can not track load times.

I am also a Tableau admin and we are able to track all these and more with LogShark (both server and online version). Does anyone know if there are 3rd party software to make this happen?

[David_E]

@tondeli  were you able to find a solution to your question regarding trackign and monitoring load times for reports?  I'd also like to be able to tell if reports are meeting SLAs and track/be alerted in cases of when they fail or miss targets.  Running it in the analyser is nice, but seeing how it performs over time "in the wild" when users are hitting it is critical.