Thoughts on data engineering, state of AI, Microsoft Fabric & Power BI.
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.
There's no native move option in the Fabric portal. Here's how to do it with a .bacpac export and import using the SqlPackage CLI.
AI can speed up Power BI development, but DAX is still a sharp edge. Benchmarking 70 models shows the biggest failure pattern is not weak business logic, but DAX grammar.
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.
Vibe coding removes the friction that used to force natural pauses. The result is a new kind of addiction - and a cognitive overload nobody's talking about.
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.
A systematic benchmark of large language models on Power BI formula generation reveals which AI assistants are worth using—and why most of them fail on the same patterns.
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 see Finance teams spending days and weeks building Excel forecasts that break the moment business patterns shift. There's a better way. I just published a...
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...
For those who would like to generate dummy/synthetic data for Accounts Receivable , use Python script below. It can be run in Google Collab notebook if you...
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...
Join me, as I take a pivotal step towards publishing my first app on the App Store by enrolling in the Apple Developer Program. This video provides a...
It’s official - my iOS app is out in the AppStore! 🎉 You can find more details here .
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...
In February, I embarked on an unexpected detour in my app development and 100 Days of SwiftUI journey, veering into what's known as "tutorial hell". The...
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...
Hey everyone! My latest video is live on Introverted Manager YouTube channel. This time, I’m diving into how to get your iPhone ready for app testing with...
Hello-hello, fellow introverts and tech enthusiasts! Maxim here, bringing you another weekly review filled with Swift discoveries and budget musings. Let's...
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...
100 Days of SwiftUI: The Halfway Mark I'm on day 42 of the '100 Days of SwiftUI' challenge, and this week has been a mix of anticipation and realizations....
Hello, hello, everyone! It’s time for another weekly catch-up. This week, I’m taking you deeper into my journey with Swift, a code review of my recent...
Learning Swift: A 100-Day Challenge Before diving into the Swift programming language, I sought advice from the Reddit iOS development community. The...
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...
At the end of the year I had decided to give myself some time off and visited two countries - Thailand and Portugal. Thailand was planned quite...
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...