John Kerski
@jkerski.bsky.social
I'm a data engineer with a passion for DataOps.
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
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
November 5, 2025 at 5:08 PM
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
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
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:
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:
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…
www.youtube.com
November 3, 2025 at 5:06 PM
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:
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:
🎥 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.
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.
October 19, 2025 at 1:44 PM
🎥 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.
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.
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...
I've shared a template to help. It tracks changes to Reports and Semantic Models and publishes to your workspace.
👉 github.com/kerski/fabri...
October 15, 2025 at 12:02 PM
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...
I've shared a template to help. It tracks changes to Reports and Semantic Models and publishes to your workspace.
👉 github.com/kerski/fabri...
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
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
October 12, 2025 at 1:44 PM
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
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
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
🔹Databricks + Foundry Support - Detects import modes & flags where incremental refresh can cut CUs on Fabric.
Get your first month free with PQLINTOCT25 → powerquerylint.com
October 7, 2025 at 5:15 PM
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
🔹Databricks + Foundry Support - Detects import modes & flags where incremental refresh can cut CUs on Fabric.
Get your first month free with PQLINTOCT25 → powerquerylint.com
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
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
October 4, 2025 at 1:32 PM
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
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
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...
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...
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.
www.youtube.com
September 30, 2025 at 5:31 PM
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...
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...
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:
💻 This is a free, online event and I’ll be showing features that are free to use.
👉 Register here:
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
www.meetup.com
September 18, 2025 at 1:06 AM
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:
💻 This is a free, online event and I’ll be showing features that are free to use.
👉 Register here:
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-...
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-...
September 16, 2025 at 4:31 PM
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-...
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-...
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...
✅ Speed up semantic model reviews
✅ Guidance for new Power Query users
✅ Free online session 🙂
Register: www.meetup.com/nashville-mo...
September 14, 2025 at 2:26 PM
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...
✅ Speed up semantic model reviews
✅ Guidance for new Power Query users
✅ Free online session 🙂
Register: www.meetup.com/nashville-mo...
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).
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).
September 9, 2025 at 5:15 PM
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).
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).
🎥 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 ✅
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 ✅
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.
youtu.be
September 3, 2025 at 6:01 PM
🎥 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 ✅
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 ✅
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
✅ 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
August 29, 2025 at 11:24 PM
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
✅ 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
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
Commenting your code saves you and your team serious time.
🎥 New video: Why comments matter + how Power Query Lint helps
- YouTube
Enjoy the videos and music you love, upload original content, and share it all with friends, family, and the world on YouTube.
youtu.be
August 26, 2025 at 10:03 PM
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
Commenting your code saves you and your team serious time.
🎥 New video: Why comments matter + how Power Query Lint helps
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
youtu.be/QdVmDNaGGek
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:…
www.youtube.com
August 23, 2025 at 12:36 PM
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
youtu.be/QdVmDNaGGek
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
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
August 12, 2025 at 11:05 PM
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
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
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:
I’ll share techniques and free templates to make your Power BI reports and models more data-driven.
Free online event, register now:
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 &…
datadrivencommunity.com
August 10, 2025 at 12:35 PM
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:
I’ll share techniques and free templates to make your Power BI reports and models more data-driven.
Free online event, register now:
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
✅ Tips to reduce risk in Power BI Desktop
✅ Use Power Query Lint's Scan TMDL feature for insights
Watch here: youtu.be/O1sXXYzMcsM
August 9, 2025 at 12:36 PM
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
✅ Tips to reduce risk in Power BI Desktop
✅ Use Power Query Lint's Scan TMDL feature for insights
Watch here: youtu.be/O1sXXYzMcsM
Quick tip: To call Kusto (Eventhouse) APIs in Microsoft Fabric with a service principal, use this token scope: kusto.kusto.windows.net/.default
August 4, 2025 at 8:05 PM
Quick tip: To call Kusto (Eventhouse) APIs in Microsoft Fabric with a service principal, use this token scope: kusto.kusto.windows.net/.default
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.
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.
July 30, 2025 at 3:27 PM
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.
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.
What is Power Query Lint?
It helps you identify issues and enforce best practices in Power Query across your Power BI semantic models.
📺 Watch the introduction video: youtu.be/djHiq2aRpnc
Use code JULYAPI2025 for your first month free. Cancel anytime.
It helps you identify issues and enforce best practices in Power Query across your Power BI semantic models.
📺 Watch the introduction video: youtu.be/djHiq2aRpnc
Use code JULYAPI2025 for your first month free. Cancel anytime.
July 27, 2025 at 1:44 PM
What is Power Query Lint?
It helps you identify issues and enforce best practices in Power Query across your Power BI semantic models.
📺 Watch the introduction video: youtu.be/djHiq2aRpnc
Use code JULYAPI2025 for your first month free. Cancel anytime.
It helps you identify issues and enforce best practices in Power Query across your Power BI semantic models.
📺 Watch the introduction video: youtu.be/djHiq2aRpnc
Use code JULYAPI2025 for your first month free. Cancel anytime.
TMDL View in Power BI Desktop is a game changer. One click gives you your model's full definition.
You can also paste it into Power Query Lint Pro to lint all partitions and expressions at once.
Faster reviews. Cleaner code.
pqlint.com
You can also paste it into Power Query Lint Pro to lint all partitions and expressions at once.
Faster reviews. Cleaner code.
pqlint.com
June 23, 2025 at 2:08 PM
TMDL View in Power BI Desktop is a game changer. One click gives you your model's full definition.
You can also paste it into Power Query Lint Pro to lint all partitions and expressions at once.
Faster reviews. Cleaner code.
pqlint.com
You can also paste it into Power Query Lint Pro to lint all partitions and expressions at once.
Faster reviews. Cleaner code.
pqlint.com
A teacher once said to me: “Commenting code is like cleaning your guest bathroom, tedious but appreciated.”
Now it’s easier with Azure OpenAI + Power Query Lint Pro:
✅ Auto-comment
✅ Rename steps
✅ Validate code
Let AI clean up your M code 👉 pqlint.com
Now it’s easier with Azure OpenAI + Power Query Lint Pro:
✅ Auto-comment
✅ Rename steps
✅ Validate code
Let AI clean up your M code 👉 pqlint.com
June 19, 2025 at 1:27 PM
A teacher once said to me: “Commenting code is like cleaning your guest bathroom, tedious but appreciated.”
Now it’s easier with Azure OpenAI + Power Query Lint Pro:
✅ Auto-comment
✅ Rename steps
✅ Validate code
Let AI clean up your M code 👉 pqlint.com
Now it’s easier with Azure OpenAI + Power Query Lint Pro:
✅ Auto-comment
✅ Rename steps
✅ Validate code
Let AI clean up your M code 👉 pqlint.com
At Power BI Days DC, we ran a Power Query Escape Room with 10 puzzles. To auto-check answers, we used CFT's new Power Query Lint tool: 👉 pqlint.com - Free version has 20 rules, paid has 60+ rules, TMDL linting & OpenAI auto-commenting. Try it out!
June 18, 2025 at 4:25 PM
At Power BI Days DC, we ran a Power Query Escape Room with 10 puzzles. To auto-check answers, we used CFT's new Power Query Lint tool: 👉 pqlint.com - Free version has 20 rules, paid has 60+ rules, TMDL linting & OpenAI auto-commenting. Try it out!