John Kerski
@jkerski.bsky.social
📤 235
📥 45
📝 81
I'm a data engineer with a passion for DataOps.
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
4 days 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
8 days 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
11 days 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
18 days 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
29 days 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-...
about 1 month 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-...
about 1 month 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/
about 1 month 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-...
about 1 month 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!
about 1 month 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/
about 1 month 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/
about 1 month 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/
about 1 month 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/
about 1 month 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
about 2 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 . . .
about 2 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
about 2 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/
about 2 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...
about 2 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/
about 2 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...
about 2 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
about 2 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...
2 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
2 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...
2 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
2 months ago
0
2
0
New post: Making Your Power BI Teams More Analytic with Microsoft Fabric Track issues by branch with Real-Time Intelligence and enforce branch policies during Pull Requests. Learn how to set up: ✅ Branch policies ✅ Pipelines ✅ PRs in Azure DevOps
loading . . .
Making Your Power BI Teams More Analytic with Microsoft Fabric - Branch Policies
Making Your Power BI Teams More Analytic with Microsoft Fabric - Branch Policies
https://www.kerski.tech/making-your-power-bi-teams-more-analytic-with-fabric-7-branch-policies/
2 months ago
0
1
1
Discover an exciting upcoming feature in Power Query Lint! In this video, I show how it not only detects issues in Power Query but also uses AI to automatically rewrite and optimize your code for better performance and maintainability. 🎥 Watch the demo here:
youtu.be/yyFwelN7yHg
2 months ago
0
1
0
New Video Drop! Ever had trouble unpivoting data with null values in Power Query? You're not alone. In this quick demo, I show how Power Query Lint can catch a common mistake and how to fix it fast. 🎥 Watch here:
loading . . .
Potential Issue: Unpivot Columns & Null Values in Power Query
In this video, I demonstrate how Power Query Lint detects a common issue when unpivoting data that contains null values and how to quickly fix it.
https://youtu.be/pHx3tieoCyM
3 months ago
0
0
1
Power Query is everywhere in Microsoft tools. We built Power Query Lint to help you write better M code, faster. It scans your code, flags issues, and saves you time. 🔗
pqlint.com
📺
youtube.com/@pqlint
3 months ago
0
3
0
New Power Query Lint Video! In this video, I show how Power Query Lint helps catch cell-level errors in your code, especially when using Record.Field with SharePoint data. I walk through a real-world example and explain how to fix it. 📺 Watch here:
loading . . .
Potential Issue: Using Record.Field can lead to Cell-Level Errors
In this video, I demonstrate how pqlint.com helps identify potential cell-level errors in your Power Query code, especially when using Record.Field. This issue is commonly seen when importing data…
https://www.youtube.com/watch?v=Lqb0c3574Rc&feature=youtu.be
3 months ago
0
0
1
🎥 New video on Power Query Lint! Learn how to speed up Power BI model refreshes when importing SharePoint List data using Power Query Lint. Watch here:
youtu.be/XGPD4PV_G-A
Try the Pro version free with code PQLINTOCT25 at checkout. Cancel anytime.
3 months ago
0
2
0
How do you get started using Fabric CLI and GitHub Actions for Power BI? I've shared a template to help. It tracks changes to Reports and Semantic Models and publishes to your workspace. 👉
github.com/kerski/fabri...
4 months ago
0
4
0
We've had lots of requests about GitHub Actions, and our new video covers it! See how to integrate Power Query Lint API with GitHub Actions in your Power BI development. Use code PQLINTOCT25 for your first month free of Power Query Lint Pro:
youtu.be/mnimnwinF2Y
4 months ago
0
0
0
New in Power Query Lint Pro! 🔹Databricks + Foundry Support - Detects import modes & flags where incremental refresh can cut CUs on Fabric. Get your first month free with PQLINTOCT25 →
powerquerylint.com
loading . . .
4 months ago
0
1
0
Using Web.Contents in Power Query? If you don’t use the Relative Path parameter, it could break in the Power BI Service. My latest video shows how Power Query Lint flags this issue and how to avoid it.
youtu.be/vPVszRKqa-8
4 months ago
0
1
0
Are you importing files from SharePoint into Power BI or Power Pivot? 📂 In my latest video, I walk through a potential issue that Power Query Lint can detect. Many people miss it when filtering for files because they don’t consider case sensitivity. Check it out:
www.youtube.com/watch?v=j4wc...
loading . . .
Potential Issue - SharePoint Files & Filtering File Types
In this video, I highlight a potential issue that may occur when filtering specific file types in SharePoint.
https://www.youtube.com/watch?v=j4wceI44-to
4 months ago
0
1
0
Tomorrow (Sept. 18) at 12:30 PM Eastern, I’ll be demonstrating Power Query Lint at the Nashville Power BI User Group. 💻 This is a free, online event and I’ll be showing features that are free to use. 👉 Register here:
loading . . .
Power Query Lint: Enhancing M Code Performance and Quality, Thu, Sep 18, 2025, 11:30 AM | Meetup
Power Query Lint is an innovative web-based tool aimed at improving the quality, readability, and performance of Power Query M code, which is essential for data transformat
https://www.meetup.com/nashville-modern-excel-user-group/events/310154031/
4 months ago
0
2
1
New release for Power Query Lint! You can now try a free API version to run checks in your Azure DevOps pipeline. Setup guide + best practices 👉
blog.kerski.tech/making-your-...
4 months ago
0
1
0
Excited to share Power Query Lint at the Nashville Power BI User Group this Thursday, Sept 18! ✅ Speed up semantic model reviews ✅ Guidance for new Power Query users ✅ Free online session 🙂 Register:
www.meetup.com/nashville-mo...
5 months ago
0
1
0
New Video Posted! 🎥 I cover how Power Query Lint can help you avoid a frustrating issue with parameters before you hit that publish button. Watch here:
youtu.be/iXc9Kh0cYcQ
Use coupon code PQLINTSEP25 for the first month free (cancel anytime).
5 months ago
1
2
0
🎥 New Power Query Lint Video! Rule: Use Table.Buffer Before Table.RemoveDuplicates to Preserve Sort Order This subtle issue keeps showing up in peer reviews. Now it’s automated with Power Query Lint ✅
loading . . .
Potential Issue: Sorting and Removing Duplicates
In this video, I walk through a potential issue that can occur when sorting and removing duplicates in Power Query.
https://youtu.be/1eIvrXmi4iM
5 months ago
0
0
1
Two new rules in Power Query Lint Pro! ✅ Use List.Buffer with List.Contains to avoid slow refreshes ✅ Use SharePoint.Contents instead of filtering SharePoint.Files to save time & capacity Build better semantic models 👉
pqlint.com
Code AUGAPI2025 = 1st month free
loading . . .
5 months ago
0
1
1
Seeing “Added Custom15” in your Power Query steps? Commenting your code saves you and your team serious time. 🎥 New video: Why comments matter + how Power Query Lint helps
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/6qQycs89NFo
5 months ago
0
1
0
Want to automate checking Power Query in semantic models for issues and best practices? See how to use a Microsoft Fabric Notebook with Power Query Lint Pro's API to catch issues before production. Code AUGAPI25 for 1 month free.
youtu.be/QdVmDNaGGek
loading . . .
Power Query Lint API with Fabric Notebooks
In this video, I show you how to lint the Power Query code inside your Semantic Models using Microsoft Fabric Notebooks. Link to notebook file referenced in the video:…
https://www.youtube.com/watch?v=QdVmDNaGGek&feature=youtu.be
5 months ago
0
0
1
Want to automate checking your Power Query in semantic models? Power Query Lint Pro has an API! See how to use Azure DevOps Pipelines to catch issues & enforce best practices before production. Use code AUGAPI25 for 1 month free. 🎥
youtu.be/EjXEYyAnB6U
6 months ago
0
2
0
I'm excited to speak at the Future Data Driven Summit on Sept 24, 2025! I’ll share techniques and free templates to make your Power BI reports and models more data-driven. Free online event, register now:
loading . . .
Future Data Driven summit 2025: Registration
Future Data Driven is a marquee, online event focusing on the comprehensive Microsoft Data Platform. Our mission is to inform and update attendees with Data & AI, DevOps & DataOps, PowerBI &…
https://datadrivencommunity.com/fdd2025registration.html
6 months ago
0
2
0
Sharing TMDL scripts in Power BI? Before you hit "Apply," make sure you understand what that script is doing. ✅ Tips to reduce risk in Power BI Desktop ✅ Use Power Query Lint's Scan TMDL feature for insights Watch here:
youtu.be/O1sXXYzMcsM
6 months ago
0
1
0
Quick tip: To call Kusto (Eventhouse) APIs in Microsoft Fabric with a service principal, use this token scope:
kusto.kusto.windows.net/.default
6 months ago
0
1
1
TMDL View in Power BI Desktop lets you analyze, review & back up semantic model definitions. See how to scan your model’s Power Query for issues & best practices with Power Query Lint Pro: 🔗
youtu.be/66A_RJbExXg
Use code JULYAPI2025 by July 31 for your 1st month free.
6 months ago
0
1
0
Load more
feeds!
log in