GitHub Models are being retired. In this video, I show how to use Azure Foundry with GitHub Actions to auto-comment Power Query code for better maintainability and AI readiness: youtu.be/RQ-YeskesT4

Power Query has no native regex, but you can use LLMs as a workaround. This video shows the pattern with Gen1 and Gen2 Dataflows. youtu.be/-Fk0wUY0CKk

pytest for Python. jest/npm test for JS. tSQLt for SQL Server. pql-test for Power BI. Automate model testing with PQL.Assert and UDFs now GA. Video: youtu.be/bMT5nkTsWEg

Automated testing for Power BI models is getting easier. In my next video, I show pql-test (preview) to standardize validation with PQL.Assert. With UDFs now GA, bring repeatable testing to your semantic model. Stay tuned.

UDFs in Power BI are now GA. CFT is working to make PQL.Assert the "npm test" of Power BI. 1.6K+ downloads so far. Try our new pql-test CLI on TestPyPI. Limited testers, sign up by June 8. forms.office.com/r/GvtV802zpe

New video: automate Fabric Data Agent testing with Promptfoo using service principals. Run prompts at scale, validate results fast, and reduce manual UI testing. Template repo included. youtu.be/42dDpCkdDow

New video: Test prompts with Promptfoo + GitHub Models. Run locally and in GitHub Actions, reduce UI testing, validate changes, and catch regressions early. youtu.be/pvX006M_kCM

Use GitHub Models + Codestral to auto-comment Power Query in GitHub Actions. Combine deterministic workflows with targeted AI for better, more maintainable code. youtu.be/HnR9j_JvbfU

New video showing how to set up the Power BI Modeling MCP Server, Service Principal, and a GitHub Cloud Agent to query a Fabric semantic model and spot issues in under 3 minutes. youtu.be/_AEoBEhHDSs

🎬 New video for the AI-Enabled Power BI Developer. Learn how deterministic checks and agentic patterns with GitHub Agentic Workflows automate Power BI report reviews and fixes. youtu.be/uGGjoX6XRPg

New video: Using GitHub Agentic Workflows to automate Power BI development. Learn how agent instructions, security controls, GitHub Actions, and the Power BI Modeling MCP Server work together. youtu.be/UJFHF6UcBrI

New video on PQL.Assert, a comprehensive set of DAX functions for testing your Power BI semantic models. In this video, I show how to run Object-Level Security tests with PQL.Assert to ensure your semantic model exposes only appropriate data to report consumers. youtu.be/E9KSCvSl3AY

How to Test Row-Level Security in Power BI In this video, I walk through how to run Row Level Security tests using PQL.Assert. youtu.be/V4TIOaeLUbI

New Video: Linting and Fixing Power Query Issues with GitHub Copilot In this video, I show how the Power Query Lint VS Code Extension sets up a custom agent to lint your Power Query code and automatically apply fixes. Watch here: youtu.be/iniih_-5TyQ

In Part 5 of this multi‑part series, I walk through how to use the Power Query Lint extension for Visual Studio Code to automatically create, update, and run tests for your semantic model using PQL.Assert and GitHub Copilot. Watch here: youtu.be/YZa9VAZ7Vl8

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

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

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-...

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!

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