Solving for slow running reports

We reviewed during our last community meeting how to run metrics to discover the health of our Power BI Premium environment.  We exhibited how to get metrics such as; average and maximum query durations, average query wait times, average dataset and dataflow refresh times. 

So what if you have a long running query and/or users saying that reports are running slow, How do you Debug?

Areas to research:

  • Too many visuals on one page?  Demo Performance Analyzer
  • DAX not optimized or not using DAX best practices? Demo Tabular Editor and Best Practice Analyzer
  • Data Model with an incorrect schema? Discuss Star Schema

View the recording here!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s