PBIMCR presents Microsoft's Chris Webb & Joe Billingham

## Details

When: Thursday 29th May 2025
Time: arrive for 5:45pm with talks starting from 6pm start prompt
Location: Slalom, Bloc Building, 17 Marble St, Manchester M2 3AW
Session will not be streamed over MS Teams
Complimentary drinks & pizza provided by our hosts & sponsors Robert Walters

May's PBIMCR will feature .....
Speaker Details -
the man
the myth
the legend...
Chris Webb (Microsoft) with:
The complete guide to Power BI memory usage and memory errors
If you've ever seen the "The visual has exceeded the available resources" error in a Power BI report or had your semantic model refresh with a "Resource governing" error, this is the session for you. In it you'll find out how Power BI semantic models use memory, how you can measure memory usage, when and why memory errors occur and what you can do to fix them.

Joe Billingham
Consultant @ Purple Frog Systems

### The DAX Speed Blueprint: Locate, Understand, Accelerate

#### Description

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.

About Joe:
For more than a decade. I've been involved in the fascinating world of data! From SQL Server and SSIS, to Azure Data Factory, Synapse, Power BI, and more recently, Fabric. Day-to-day I'm a senior member of the data engineering team at Purple Frog Systems and in my spare time I run the Microsoft Data Platform Birmingham user group as well as my own blog.

Running a user group allows me to connect with amazing folks and either teach or learn from like-minded people. I've had the privilege of speaking at various user groups and conferences, giving back to the community wherever I can.

There's more to me than just data! I'm also the creator of the Data Luthier blog, where I talk all things tech and give a sneak peek into my other passion: guitars! Yup, I'm a total guitar geek – from playing to collecting, fixing, and even crafting my instruments.