Semantic Model Optimization: Theory, Tips and Tools
Here is a talk I gave at the Vancouver Fabric & Power BI User Group on Semantic Model Optimization:
2025¶
MCP Server: DAX Performance Tuner
With all of the buzz around MCP servers, I wanted to see if one could be created that would help you optimize DAX. Introducing - DAX Performance Tuner!
Identifying Semantic Model Capacity Spikes Using Workspace Monitoring
Part of my role is to monitor our team's Fabric capacity utilization, and one of the main tools we use is the Capacity Metrics app. I'm sure this never...
DAXing with DAX Noob: Episode 3
On this episode of DAXing with DAX Noob, we walk through two DAX problems posted on the Power BI Reddit channel and LinkedIn that involve some set functions...
Extracting Semantic Model Source Tables with Fabric Notebooks
In an internal Microsoft Fabric support channel, someone asked, "My customer has multiple workspaces, each containing several semantic models. They are...
DAXing with DAX Noob: Episode 2
On this episode of DAXing with DAX Noob, we walk through two DAX problems posted on the Power BI Reddit channel that involve some tricky evaluation context.
DAXing with DAX Noob: Episode 1
On this first episode of DAXing with DAX Noob, I walk through solving a question on the Fabric Community forum about a broken YTD Forecast measure.
Fabric Toolbox: Semantic Model Audit
Another role of the Azure Data Insights & Analytics team is building and maintaining the internal analytics and reporting for Azure Data. My job is to...
Fabric Toolbox: DAX Performance Testing
Part of the role of the Azure Data Insights & Analytics team is to test new features and provide feedback to our engineering and product teams. However,...
