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