John Kerski
@jkerski.bsky.social
š¤ 238
š„ 45
š 105
I'm a data engineer with a passion for DataOps.
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
about 8 hours ago
1
0
0
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
12 days ago
0
3
0
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
21 days ago
0
3
1
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.
22 days ago
0
1
1
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
23 days ago
0
1
0
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
28 days ago
0
2
1
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
about 1 month ago
0
4
1
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
about 1 month ago
0
2
0
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
about 2 months ago
0
1
2
š¬ 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
about 2 months ago
0
0
1
New video out! In this video, I walk how skills files can be used to review and update your Power BI reports and semantic models within the Mobile. Learn how to accelerate, parallelize, and delegate your work thanks to these skills files from Rui Romano's repository.
loading . . .
- YouTube
Enjoy the videos and music you love, upload original content, and share it all with friends, family, and the world on YouTube.
https://youtu.be/UvLdy02dSZs
2 months ago
0
2
2
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
2 months ago
1
4
1
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
3 months ago
0
1
1
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
3 months ago
0
1
0
New Video for the AI-Enabled Power BI Tester In this video, I walk through how to display test results from PQL.Assert directly in a Power BI report. This approach adds transparency for report consumers & helps build confidence in the data they're using.
loading . . .
- YouTube
Enjoy the videos and music you love, upload original content, and share it all with friends, family, and the world on YouTube.
https://youtu.be/7dvr2CDjVh4
3 months ago
0
2
2
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
3 months ago
0
2
1
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
3 months ago
0
2
0
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
4 months ago
0
1
1
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
4 months ago
0
1
0
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
4 months ago
0
1
0
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
4 months ago
0
0
0
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!
loading . . .
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ā¦
https://youtu.be/tqBzH2Zu9c4
4 months ago
0
1
1
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
5 months ago
0
4
1
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
5 months ago
0
1
1
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
5 months ago
0
1
0
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
5 months ago
0
1
1
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
5 months ago
0
1
1
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.
loading . . .
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ā¦
https://youtu.be/PHjQqkCRTxY
6 months ago
0
1
0
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
6 months ago
0
0
0
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 months ago
0
1
0
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-...
6 months ago
0
1
0
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
loading . . .
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
https://blog.kerski.tech/making-your-power-bi-teams-more-analytic-with-fabric-5-semantic-model-analysis/
6 months ago
0
1
0
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-...
6 months ago
0
1
0
š 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!
6 months ago
0
2
1
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
loading . . .
Making Your Power BI Teams More Analytic with Microsoft Fabric - Tracking Changes
Making Your Power BI Teams More Analytic with Microsoft Fabric - Tracking Changes
https://blog.kerski.tech/making-your-power-bi-teams-more-analytic-with-fabric-3-tracking-changes/
6 months ago
0
1
0
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
loading . . .
Making Your Power BI Teams More Analytic - Foundation
Making Your Power BI Teams More Analytic with Microsoft Fabric - The Foundation
https://blog.kerski.tech/making-your-power-bi-teams-more-analytic-with-fabric-2-foundation/
6 months ago
0
1
0
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
loading . . .
Making Your Power BI Teams More Analytic with Microsoft Fabric - Introduction
Making Your Power BI Teams More Analytic with Microsoft Fabric - Introduction
https://blog.kerski.tech/making-your-power-bi-teams-more-analytic-with-fabric-1-introduction/
6 months ago
0
1
1
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:
loading . . .
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
https://www.red-gate.com/simple-talk/business-intelligence/13-things-i-wish-i-knew-about-power-query/
6 months ago
0
3
1
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
7 months ago
0
1
1
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
loading . . .
7 months ago
0
2
1
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.
loading . . .
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",ā¦
https://www.youtube.com/watch?v=Ala6PHlYjmw
7 months ago
0
2
0
My thoughts on the state of Fabric Real-time from a DataOps perspective.
loading . . .
Bringing DataOps to Fabricās Real-Time Capabilities
Bringing DataOps to Fabricās Real-Time Capabilities
https://blog.kerski.tech/bringing-dataops-to-fabric-real-time-capabilities/
7 months ago
0
4
0
š 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...
7 months ago
0
1
0
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...
loading . . .
Bringing DataOps to Fabricās Real-Time Capabilities
Bringing DataOps to Fabricās Real-Time Capabilities
https://blog.kerski.tech/bringing-dataops-to-fabric-real-time-capabilities/
7 months ago
0
2
0
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...
7 months ago
0
1
0
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
7 months ago
0
1
0
š 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...
7 months ago
0
2
1
Want to make your Power Query transformations leaner and faster? In my latest video, I show how Power Query Lint can help you eliminate unnecessary steps by using a powerful yet often overlooked parameter when splitting columns.
youtu.be/cO2lk5MWhtQ
7 months ago
0
1
0
The pace of AI & Agent news in the Microsoft ecosystem has been staggering, & the new capabilities are exciting. In my latest post, I share practical thoughts on how to approach agent development based on real experiences. Read it here:
blog.kerski.tech/teaching-age...
7 months ago
0
2
0
Curious about a longer form video on Power Query Lint? I had the privilege of joining the Nashville Power BI User Group this past September to present on Power Query Lint. š„ Watch the session here:
loading . . .
Power Query Lint: Enhancing M Code Performance and Quality
šļø Presented by: John Kerski ā Director, Microsoft Technologies, Client First Technologies Power Query Lint is an innovative web-based tool aimed at improving the quality, readability, andā¦
https://youtu.be/z8jtl307nPQ?si=IMjVFzK14BFUIBhU&t=1157
7 months ago
0
2
0
Load more
feeds!
log in