DAX
-
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: Continue reading
-
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! The MCP server give LLMs the tools it needs to optimize your DAX queries using a systematic, research-driven process. How it works: After the LLM connects to Continue reading
-
Identifying Semantic Model Capacity Spikes Using Workspace Monitoring
Introduction 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 happens to you 😉, but our semantic models sometimes cause our utilization to cross the 100% threshold. Unfortunately, getting the details you need to identify Continue reading
-
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 and optimizing a Days of Supply measure. Links to the DAX challenges:https://www.linkedin.com/posts/kubisco_dax-challenge-activity-7327966442144903168-g8I9 https://www.reddit.com/r/PowerBI/comments/1kml57r/need_help_with_optimisation_of_a_measure/ Continue reading
-
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. Continue reading
-
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. Continue reading
-
Fabric Toolbox: Semantic Model Audit
Introduction 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 develop, maintain and optimize the Semantic Models that support our reporting. In order to monitor and audit our models’ performance, we developed a tool called Semantic Model Audit, Continue reading
-
Fabric Toolbox: DAX Performance Testing
Introduction 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, manual testing quickly becomes time-consuming and prone to error, so we develop tools and processes that let us automate and scale our testing efforts. We realized these Continue reading
-
Optimizing Rolling Distinct Count Measures
Introduction In my new role in Azure Data, I have spent a lot of time optimizing the performance of semantic models and DAX measures. One of the types of calculations we frequently use is 28-day (or 7-day) rolling distinct counts in order to see how our business is growing over time. In this post, I Continue reading
-
Reducing Semantic Model Size with Creative Solutions
Introduction When working with larger semantic models, one of the things you are constantly trying to do is to reduce the model size while still meeting stakeholder requirements. Smaller models often result in faster queries, and you need to keep models under a certain size to stay within capacity memory limits. One common problem child Continue reading
DAX Noob 