SemanticOps MCP v3.9.119: Release Notes
v3.9.119 adds HTML model reports, fully configurable DAX formatting, deeper storage diagnostics, flaky-test classification, combined Power Query commits, and new DAX debugging and performance-tuning skills.
Thoughts on data engineering, state of AI, Microsoft Fabric & Power BI.
v3.9.119 adds HTML model reports, fully configurable DAX formatting, deeper storage diagnostics, flaky-test classification, combined Power Query commits, and new DAX debugging and performance-tuning skills.
v1.1.39 adds browser and device-code sign-in, test stability classification, order-tolerant baselines, virtualized selectors, steadier run behavior, and model-scoped tests that survive migrations.
Truly agentic development requires one thing: feedback loops. Many of them. Here is how I think about building them into AI-assisted Power BI work - and why they matter more than the model itself.
Rayfin gives Power BI developers the customizability they've wanted for years, full web apps instead of constrained reports. But that freedom comes with a UX cost and an engineering cost most teams aren't pricing in yet.
SemanticOps Test Runner is a desktop app for creating and running repeatable tests against Power BI semantic models. Catch broken measures, RLS issues, performance regressions, and model-quality problems before changes reach users or production workspaces.
Most Power Query pagination examples break the moment you publish to Power BI Service. Here's a complete, production-ready pattern for cursor-based REST API pagination using Web.Contents with RelativePath, proper auth handling, and a List.Generate implementation that doesn't skip the last page.
SemanticOps MCP, formerly MCP Engine, is a local MCP server that connects AI assistants to your Power BI semantic models. Free tier covers core modeling. Pro adds rollback, test runners, policy engines, data masking, and impact analysis — the guardrails you need before letting AI touch production.
Step-by-step guide to refreshing individual tables in your Power BI semantic model using Azure Service Principal, the Enhanced Refresh REST API, and Power Automate.
Data visualization is often about consuming information quickly. But what if you could do more than just observe trends? Adding annotations directly on your...
In this video I put my Power BI Desktop MCP server v2 to a real test: can an AI agent build a complete semantic model from scratch? Using Claude Code with...
After a closed beta and a round of bug-fixes, v1.3.0 is now available for everyone. It’s an MCP server for Power BI Desktop that lets AI assistants (e.g.,...
I just demonstrated something in the new video that changes how we think about Power BI development workflows. Using MCP (Model Context Protocol), I...
Getting generic, unhelpful responses when asking ChatGPT or other AI tools for Power BI and DAX help? The problem isn't the AI - it's the lack of context...
There are 4 levels of analytics maturity: 1. Descriptive (what happened), 2. Diagnostic (why it happened),...
After years of workarounds and third-party solutions, Microsoft has delivered what the Power BI community has been asking for - true native writeback...
Stop manually testing your Power BI reports! This tutorial shows you how to create an automated unit testing system that runs daily and emails you the...
Master the calculation of working days in Power Query with this custom function tutorial! While Excel has NETWORKDAYS, Power Query lacks this capability out...
Ever been told that incremental refresh in Power BI doesn't work with non-folding data sources? 🤔 In my latest tutorial, I demonstrate step-by-step how to...
I have pushed these SVGs further than before, allowing for more customization: would like to have gradient? change one switch; would like to add sizing...
Since Microsoft introduced TMDL (Tabular Model Definition Language), I've been exploring practical applications beyond the obvious mass updates, adding...
Build beautiful progress column charts in Power BI using SVG - no custom visuals required! In this tutorial, I'll show you how to create stylish vertical...
Elevate your Power BI dashboards with this stunning funnel chart - no custom visuals required! In this walkthrough, see how to make 3 distinct funnels - for...
The time has come to share a pet project I've been working on behind-the-scenes - my take on theme editing for Power BI. And let me tell you, throughout...
Built-in gridlines and snap to grid features in Power BI are notoriously bad at helping users. For those who is as anal as I’m at aligning all of the...
Create a fully functional column variance chart in Power BI - without using any custom visuals. Discover how to set up the background, filter your data,...
Transform your Power BI reports with elegant SVG progress indicators! Learn how to build professional-looking actual vs target visualizations using native...
With Holidays around the corner, thought I would share animated SVG background I made, that can add a bit of festive mood to your reports. Assuming your...
If you’re having “ OLE DB or ODBC error: Exception from HRESULT: 0x80040E57. “ error during refreshes, there is a solution. First of all, it’s always best...
Have you ever wanted to create visually stunning, interactive visualizations in Power BI that go beyond the ordinary? In my latest YouTube video, I...
As a data-driven manager, I'm always on the hunt for ways to optimize workflows and spend less time on repetitive tasks. Enter Tabular Editor...
Elevate your data visualization skills by learning how to create stunning candlestick charts in Power BI using Deneb and Vega-Lite! This step-by-step...
Unlock Apple Stock Data in Power BI using a hidden hack from Yahoo Finance! In this tutorial, I reveal a powerful workaround to import historical stock data...
Learn how to use Power Query and M code in Power BI to compare two tables and resolve mismatches in column names and data types. Whether you’re preparing to...
Join me as I show you how to build a Period Table in Power Query to filter your data by Month-to-Date (MTD), Quarter-to-Date (QTD), Year-to-Date (YTD),...
Today, I’m showing you how to take your Power BI reports to the next level by adding custom KPI icons! Learn how to edit the theme JSON file to incorporate...
Integrating Power BI with JIRA API can greatly enhance data analysis and business intelligence tasks. However, many users encounter data refresh errors when...
Join me as re-work M code for JIRA API extraction using RelativePath to allow data refresh within Power BI Service. If you’re tired of encountering "dynamic...
Unlock the full potential of Deneb dumbbell charts in this detailed tutorial. I’ll show you how to add dynamic elements, highlight selected data points, and...
In this tutorial, I will guide you through building a custom vertical dumbbell chart in Power BI with Deneb and Vega-Lite. From setup to styling, learn how...
In this detailed walkthrough, I address the challenge of calculating rolling 3-month averages in Power BI with a disconnected date table. Watch as I explain...
Join me as I walk you through a clever workaround to enable drilldown features in Deneb visuals, which don’t support drilldown/up or field parameters by...
Learn how to apply dynamic formatting to Deneb visuals in Power BI with this guide. I will walk you through the steps to make your data labels stand out and...
Join me in this step-by-step tutorial on how to use error bars in Power BI to create a Hills and Valleys chart. Learn how to visualize the difference...
Join me as I show you how to leverage the Best Practices Analyzer in Tabular Editor to ensure your Power BI models are following best practices. Learn how...
Learn how to achieve effective version control using Microsoft Teams and SharePoint when Git is not available. I will guide you through setting it up and...
Join me as I delve into the complexities of handling multiple currencies in Power BI. This tutorial covers essential techniques to dynamically format...
Join me as we dive into optimizing report maintenance in Power BI through centralized dynamic formatting. This video will teach you how to set up a...
Join me as I dive into creating the ultimate date table in Power BI using Power Query. This advanced guide is designed for those looking to enhance their BI...
Join me today as I show you how to pull data directly from JIRA into Power BI, simplifying your data management processes. Whether you're a project manager...
Embark on this comprehensive tutorial with me as we master the technique of embedding images in Power BI using base64 encoding. This method ensures your...
Join me in a step-by-step guide on extracting data from offset-based paginated APIs using only Power BI and the M language. I'll show you how to navigate...
Join me for this hands-on guide on leveraging Power BI's Power Query and M language for extracting data from page-based paginated APIs. This video is...
In this comprehensive guide, I delve into the intricacies of cursor-based APIs - a common method for accessing large datasets page by page. What makes this...
Join me on a deeply personal journey as I explore the visualization of life expectancy data using Power BI, Deneb, and Vega. This video details my process...
In the latest tutorial on Introverted Manager, I delve into enhancing your Power BI reports with interactive app-like buttons. This feature allows you to...
In the realm of data analysis and business forecasting, linear regression stands as a pivotal tool, offering insights into future trends based on historical...
As project managers, we're in the business of problem-solving. Every project throws a curveball or two (or ten), and it's our job to navigate these...
With a solid 15-year tenure in IT and over seven years in project management, I've spent a considerable portion of my career bringing others' visions to...
I had just published project that was on my mind for a long time. And it hit close to home. Lately I was reflecting about the choices made earlier in life,...
Last time I had my own blog I was 20. Right now I’m 34. I grew, evolved, learned and changed plenty. It’s been hell of a ride. It’s time to go back to the...