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 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
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).
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
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
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!
On June 24th, I’ll be speaking at the Triangle SQL Server User Group on automatically checking for broken visuals in Power BI.
I'll share templates to help you get started, and show how to avoid that dreaded grey box of death before your users ever see it. 😅
Event link: bit.ly/3HMJou2
I'll share templates to help you get started, and show how to avoid that dreaded grey box of death before your users ever see it. 😅
Event link: bit.ly/3HMJou2
June 11, 2025 at 5:16 PM
On June 24th, I’ll be speaking at the Triangle SQL Server User Group on automatically checking for broken visuals in Power BI.
I'll share templates to help you get started, and show how to avoid that dreaded grey box of death before your users ever see it. 😅
Event link: bit.ly/3HMJou2
I'll share templates to help you get started, and show how to avoid that dreaded grey box of death before your users ever see it. 😅
Event link: bit.ly/3HMJou2
I’m excited to speak at TechCon 365 Seattle (June 23-27) on Leveraging Large Language Models with Power BI. I’ll be sharing practical examples of how I use LLMs to improve Power BI development quality, w/ tools & techniques you can start using right away.
techcon365.com/portal/
techcon365.com/portal/
June 10, 2025 at 1:36 PM
I’m excited to speak at TechCon 365 Seattle (June 23-27) on Leveraging Large Language Models with Power BI. I’ll be sharing practical examples of how I use LLMs to improve Power BI development quality, w/ tools & techniques you can start using right away.
techcon365.com/portal/
techcon365.com/portal/
Power BI Days DC is next week, June 12 & 13th!
🧩 Can you defeat Lord Taart Chart and his Power Query puzzles?
🎤 Hear from speakers in GCC/DoD tenants and take home real-world best practices.
🎟️ Free, in-person event: register now: bit.ly/4kdtVld
🧩 Can you defeat Lord Taart Chart and his Power Query puzzles?
🎤 Hear from speakers in GCC/DoD tenants and take home real-world best practices.
🎟️ Free, in-person event: register now: bit.ly/4kdtVld
June 6, 2025 at 1:49 PM
Power BI Days DC is next week, June 12 & 13th!
🧩 Can you defeat Lord Taart Chart and his Power Query puzzles?
🎤 Hear from speakers in GCC/DoD tenants and take home real-world best practices.
🎟️ Free, in-person event: register now: bit.ly/4kdtVld
🧩 Can you defeat Lord Taart Chart and his Power Query puzzles?
🎤 Hear from speakers in GCC/DoD tenants and take home real-world best practices.
🎟️ Free, in-person event: register now: bit.ly/4kdtVld
🆕 Blog Post: Power Query + Multiple Value Parameters in Paginated Reports
Power Query in Paginated Reports is underrated, especially for handling multiple value parameters.
Learn how to ditch RSCustomDaxFilter bit.ly/3Fl7kEk
Power Query in Paginated Reports is underrated, especially for handling multiple value parameters.
Learn how to ditch RSCustomDaxFilter bit.ly/3Fl7kEk
June 4, 2025 at 4:36 PM
🆕 Blog Post: Power Query + Multiple Value Parameters in Paginated Reports
Power Query in Paginated Reports is underrated, especially for handling multiple value parameters.
Learn how to ditch RSCustomDaxFilter bit.ly/3Fl7kEk
Power Query in Paginated Reports is underrated, especially for handling multiple value parameters.
Learn how to ditch RSCustomDaxFilter bit.ly/3Fl7kEk
10 refreshes a piece on a F2 capacity. Each refresh is isolated and nothing else runs during each refresh:
June 4, 2025 at 1:30 PM
10 refreshes a piece on a F2 capacity. Each refresh is isolated and nothing else runs during each refresh:
Testing a new version of "A Faster way to import SharePoint list data into Power BI"
github.com/kerski/power...
Still running tests (see below), but excited to discuss it at Power BI Days DC!
powerbidc.org
github.com/kerski/power...
Still running tests (see below), but excited to discuss it at Power BI Days DC!
powerbidc.org
June 3, 2025 at 6:15 PM
Testing a new version of "A Faster way to import SharePoint list data into Power BI"
github.com/kerski/power...
Still running tests (see below), but excited to discuss it at Power BI Days DC!
powerbidc.org
github.com/kerski/power...
Still running tests (see below), but excited to discuss it at Power BI Days DC!
powerbidc.org
Are you ready for the Power Query Escape Room at Power BI Days DC, happening June 12-13?
Put your M skills to the test against Lord Taart Chart, pick up new skills, & connect with fellow PBI enthusiasts.
Register now for this free, in-person event: bit.ly/4kdtVld
Put your M skills to the test against Lord Taart Chart, pick up new skills, & connect with fellow PBI enthusiasts.
Register now for this free, in-person event: bit.ly/4kdtVld
June 2, 2025 at 4:15 PM
Are you ready for the Power Query Escape Room at Power BI Days DC, happening June 12-13?
Put your M skills to the test against Lord Taart Chart, pick up new skills, & connect with fellow PBI enthusiasts.
Register now for this free, in-person event: bit.ly/4kdtVld
Put your M skills to the test against Lord Taart Chart, pick up new skills, & connect with fellow PBI enthusiasts.
Register now for this free, in-person event: bit.ly/4kdtVld