John Kerski

Part 4 of The AI‑Enabled Power BI Tester is out!

In this video, you will see how Custom Agents and Skills in GitHub Copilot can automatically create, update, and run tests against your semantic model with PQL.Assert.

Watch Part 4: youtu.be/5c8Mr_QldKY

The AI-Enabled Power BI Tester – Part 3: Power Automate is live!

In this video, I walk through how to use Power Automate to automatically run tests, using PQL.Assert, against semantic models published to the Power BI service.

Watch Part 3 here:

youtu.be/NMSGRRWo89Q

Part 2 of “The AI‑Enabled Power BI Tester” is live.

This video is the second in our multi‑part series on using AI effectively to validate & test your Power BI semantic models. In this episode, we cover naming conventions for tests & show how to create tests for DAX measures.

youtu.be/f_9fnJgMZWE

Part 1 of our new Power Query Lint series is live. Learn how AI can enhance testing and validation of your Power BI semantic models. In this episode, we install the PQL.Assert function set to enable structured and repeatable model testing.

youtu.be/DQ-6x6CpoKI

The AI-Enabled Power BI Developer - Part 5 - Power Query Lint MCP Server Part 5 of our AI‑Enabled Power BI Developer series walks you through setting up and using the Power Query Lint MCP Server. Learn how to integrate automated code checks into your workflow and boost…

Part 5 of the AI‑Enabled Power BI Developer series is out. Learn how to use the Power Query Lint MCP to check your Power Query code for potential issues and best practices. New series, AI‑Enabled Power BI Tester, starts Saturday!

Last year my company shipped Power Query Lint to help you clean up your PQ code. Now we're launching PQL.Assert, a testing framework for semantic models powered by DAX UDFs.

We'll be rolling out videos over the next month, but you can dive in now:
🔗 www.pqlint.com/pql-assert

Part 4 of the AI Enabled Power BI Developer series is live! Learn how to use Background and Cloud Agents in GitHub Copilot and manage AI changes safely. Watch here: youtu.be/SMtPsj8guII

In Part 3 of our series on becoming an AI‑Enabled Power BI Developer, we walk through how to use GitHub Copilot alongside the Power BI Modeling MCP Server to make updates to your semantic model.

🎥 Watch Part 3: youtu.be/9uSEFFsPQeo

Join me at the Power BI and Fabric Summit 2026, happening February 23-27.

I'll be presenting: Querying SharePoint Data in Power BI - Options & Performance

🎥 Want a sneak peek? Check out my video: youtu.be/v46AGT8b1mE

Part 2 of the AI-Enabled Power BI Developer series is live!

In this episode, we dive into the Power BI Project (PBIP) format and explore how to get started with GitHub Copilot to facilitate your development.

youtu.be/XwiT56FJd3k

The AI-Enabled Power BI Developer - Part 1 - Foundation At Power Query Lint, our goal is to help you become the most AI‑enabled Power BI developer possible. This video is Part 1 of a multi‑part series focused on using AI effectively in Power BI…

Become an AI‑Enabled Power BI Developer

Part 1 of our new video series is now live, where we walk through the foundational setup needed to use AI safely and effectively when making changes to Power BI semantic models and reports.

Special Offer for Power Query Lint ends today (December 31)!

Get a 1-year subscription for just $45 when you purchase a gift card:

app.cardivo.com/giftcards/pq...

Want to learn more about Power Query Lint? Check out the YouTube channel:

🎥 www.youtube.com/@pqlint

3 days left in 2025!

Are you looking to improve your Power BI solutions for the new year with branch policies?

Check out Part 7 of my series: Making Your Power BI Teams More Analytic with Microsoft Fabric

blog.kerski.tech/making-your-...

4 days left in 2025!

Are you looking to improve your Power BI solutions for the new year and learn a little about Fabric Real-Time?

Check out Part 6 of my series: Making Your Power BI Teams More Analytic with Microsoft Fabric
blog.kerski.tech/making-your-...

Making Your Power BI Teams More Analytic with Microsoft Fabric - Semantic Models Making Your Power BI Teams More Analytic with Microsoft Fabric - Static Analysis for Semantic Models

5 days left in 2025!

Are you looking to improve your Power BI solutions for the new year?

Check out Part 5 of my series: Making Your Power BI Teams More Analytic with Microsoft Fabric

6 days left in 2025!

Are you looking to improve your Power BI solutions for the new year?

Check out Part 4 of my series: Making Your Power BI Teams More Analytic with Microsoft Fabric

blog.kerski.tech/making-your-...

🎁 Last-minute gift for the Power BI or Power Pivot pro?
Give them Power Query Lint Pro—write cleaner code, avoid errors, deliver faster solutions.
✅ Special offer: 1-year subscription for $45
app.cardivo.com/giftcards/pq...
No credit card needed. Schedule delivery for perfect timing!

Making Your Power BI Teams More Analytic with Microsoft Fabric - Tracking Changes Making Your Power BI Teams More Analytic with Microsoft Fabric - Tracking Changes

9 days left in 2025!

Are you looking to level up your Power BI skills for the new year?

Check out Part 3 of my series: Making Your Power BI Teams More Analytic with Microsoft Fabric

Making Your Power BI Teams More Analytic - Foundation Making Your Power BI Teams More Analytic with Microsoft Fabric - The Foundation

10 days left in 2025!

Are you looking to level up your Power BI project skills for the new year?

Check out Part 2 of my series: Making Your Power BI Teams More Analytic with Microsoft Fabric

Making Your Power BI Teams More Analytic with Microsoft Fabric - Introduction Making Your Power BI Teams More Analytic with Microsoft Fabric - Introduction

11 days left in 2025!

Are you looking to level up your Power BI project skills?

Check out Part 1 of my series: Making Your Power BI Teams More Analytic with Microsoft Fabric

13 Things I wish I knew about Power Query (when I first started) When I first started with Power Query, it was in Excel, through the Power Pivot feature. I was amazed at how I could transform data with just a few clicks

2026 is just 13 days away!

Earlier this year, I wrote an article on 13 Things I Wish I Knew About Power Query When I First Started.

If you're working with Power Query or just starting your journey, I hope you find these tips helpful:

Are you working with Power BI Dataflows?

After years of working with Power BI dataflows there is a potential issue I see all the time in code reviews.

Learn how Power Query Lint easily identifies a potential issue with column types and how to avoid the issue altogether.

youtu.be/UmiGjd6o96w

Big things are coming to Power Query Lint in 2026!
Practical AI-powered features to make your Power Query better → reliable refreshes + stable code.

Curious about Power Query Lint?

Check out tips for cleaner, efficient queries in Power BI, Dataflows, & Excel on YouTube.
www.youtube.com/@pqlint

Git Will Finally Make Sense After This How Git Actually Works — finally understand commits, branches, reset, rebase & more. You use Git every day. Commit. Push. Pull. But when something breaks, you're Googling "how to undo git rebase",…

For anyone getting started with version control in Git, especially in the Power BI world, the terminology can be difficult to understand.

LearnThatStack recently released an excellent video that explains key Git terms in under 15 minutes.

Bringing DataOps to Fabric’s Real-Time Capabilities Bringing DataOps to Fabric’s Real-Time Capabilities

My thoughts on the state of Fabric Real-time from a DataOps perspective.

🎁 Looking for the perfect gift for a Power BI or Power Pivot pro?

Give them an annual subscription to Power Query Lint Pro, the tool that helps write cleaner code.

Special Offer: 1-year subscription for $45 when you purchase a gift card:
app.cardivo.com/giftcards/pq...

Bringing DataOps to Fabric’s Real-Time Capabilities Bringing DataOps to Fabric’s Real-Time Capabilities

I've been using Eventhouses to build real-time analytics in Fabric and exploring how well Real-time supports version control and testing. My thoughts are at the link below.

blog.kerski.tech/bringing-dat...

New Power Query Lint video!

I reveal how Power Query Lint uncovers a seldom-used parameter in Table.ExpandTableColumn. By taking advantage of this option, you can remove unnecessary steps and speed up refresh times.

www.youtube.com/watch?v=TTRs...

New Power Query Lint Video!

We show how Power Query Lint uncovers a rarely used parameter in Table.DuplicateColumn. By taking advantage of this option, you can simplify your queries, remove unnecessary steps, & speed up refresh times.

Watch here: youtu.be/LNCpoobKq08

🎁 Give the gift of cleaner Power Query code!
For 3 weeks, get 1-year Power Query Lint Pro access with this gift card for just $45: app.cardivo.com/giftcards/pq...

Perfect for Power BI, Power Pivot, and Dataflow devs. Learn more about Power Query Lint: www.youtube.com/watch?v=mnim...