Slow performing Power BI reports and visuals are a major cause of frustration. Finding the cause of these slow-downs and understanding why they are happening are the first steps in resolving them.

In this session we'll discuss the troubleshooting steps for slow DAX executions, using tools like Performance Analyser and DAX Studio.

We'll cover the different purposes behind the two parts of the DAX engine - Storage and Formula, and how to write expressions that target each individual component, allowing us to utilise their combined power to unlock the full potential of DAX.

We'll see how optimising expressions in order to harness the power of these engines helps increase performance. This will be done using live demonstrations showing the actual difference in executions times as well as exploring query plans.

By the end of this session, you will know how to identify which DAX expressions are causing issues in your reports, you'll have a solid understanding of what the DAX engine consists of, how the parts work together and how to use them to your advantage to make your expressions faster and more efficient. You will also know how to view a DAX query plan to help troubleshoot slow performing queries.

Slow reports? Learn to identify and fix DAX performance issues! This session covers troubleshooting with tools like Performance Analyzer and DAX Studio, understanding the DAX engine's components, and optimizing expressions for better performance