John Kerski
@jkerski.bsky.social
📤 233
📥 45
📝 49
I'm a data engineer with a passion for DataOps.
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...
3 days 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
6 days 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 . . .
10 days 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
14 days 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
17 days 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/
about 1 month 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-...
about 1 month 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...
about 1 month 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).
about 1 month 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
about 1 month 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 . . .
about 2 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
about 2 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
about 2 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
2 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
2 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
2 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
2 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.
3 months ago
0
1
0
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.
3 months ago
0
1
2
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
loading . . .
4 months ago
0
2
0
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
loading . . .
4 months ago
0
2
0
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!
loading . . .
4 months ago
0
1
0
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
4 months ago
0
1
1
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/
4 months ago
0
1
0
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
4 months ago
0
1
0
🆕 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
5 months ago
0
0
1
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
5 months ago
1
1
0
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
5 months ago
0
2
0
The Power BI Days DC speaker lineup is live for June 12-13! Learn from top experts across GCC, DoD & Commercial tenants including Stevie Wilson, Daniel Baller, David Patrick, Leslie Welch & more. 🎟️ Free in-person event - register now before it fills up:
bit.ly/4kdtVld
5 months ago
0
1
0
I just finalized my slides for TechCon 365 in Seattle (June 23-27) & updated the demos based on the latest Microsoft news. This is a great opportunity to hear from experts across the Microsoft ecosystem, like
@julieturner.net
,
@powerbisteve.bsky.social
& many others. Register today:
bit.ly/44Z7hIy
5 months ago
0
3
1
Join us at Power BI Days DC on June 12–13 and put your Power Query skills to the test with the Power Query Escape Room! Lord Taart Chart has created 10 puzzles, and he believes you cannot solve them all. Think you’re up to the challenge? Register now for this free, in-person event:
bit.ly/4kdtVld
5 months ago
0
3
0
Do you have the Power Query skills to escape Lord Taart Chart's series of puzzles? Join a team at the free, in-person Power BI Days DC event on June 12th and 13th and put your skills to the test-while picking up new ones along the way. Register before it's too late:
bit.ly/4kdtVld
5 months ago
0
4
2
Last session of the day with Belinda Allen. Learning how to do better storytelling in Power BI!
#SQLSaturdayRaleigh
5 months ago
0
4
0
Now it's a deep-dive into Power BI Row Level Security with Leslie Welch!
#SQLSaturday
Raleigh.
5 months ago
0
3
0
#SQLSaturday
Raleigh has begun! Starting off with Brent Ozar about building your brand and giving back to the community. Awesome topic.
5 months ago
0
3
1
Registration is open for Power BI Days DC: June 12-13, 2025 Free, in-person, community-led event featuring: • Keynote by Alex Powers • Power Query Escape Room • Newbie Speaker Happy Hour • DC Data Viz Competition Sign up:
powerbidc.org
loading . . .
Power BI User Group DC
Power BI DC is your DC area community organized user group focused on learning the Microsoft Fabric/Power BI platform together and connecting members with other local data nerds.
https://powerbidc.org/
5 months ago
0
1
0
My latest article for “Bringing DataOps to Power BI” is up. While commenting Power Query code is important, it takes time. Learn how to leverage Azure
#OpenAI
to automatically comment and suggest new step names based on your code, saving you time.
bit.ly/42ewAmD
#PowerBI
loading . . .
Commenting Power Query with Azure OpenAI
Part 35 – Commenting Power Query with Azure OpenAI
https://bit.ly/42ewAmD
over 1 year ago
0
3
1
With the recent release of Microsoft Fabric to General Availability in the commercial sector, I’ve revisited my thoughts on how Fabric weaves DataOps principles into the product:
bit.ly/3N6oCFO
TLDR: Progress is being made, but there is still more to do.
almost 2 years ago
0
1
0
Power Query is often surrounded w/ generic data transformation steps that lack context. Why not use Azure
#OpenAI
to add comments to your code & suggest more descriptive names? Here is an example that analyzed a PBI model using ChatGPT 4.0 to do just that:
bit.ly/49n2iBb
almost 2 years ago
1
1
0
DataOps emphasizes the automated detection of issues with your data pipelines. At present, this type of automation can be difficult with Gen1
#PowerBI
Dataflows. Check out my latest article with a free template to automate the testing of Dataflows using PowerShell.
bit.ly/3MpbrPY
.
almost 2 years ago
0
1
0
Headed out to Chicago for #365EduCon ! I am excited to talk Fabric, Power BI, and... DataOps!
almost 2 years ago
0
1
0
I'm liking the new Save As interface for the October 2023 release of
#PowerBI
desktop.
about 2 years ago
0
2
0
My latest entry for “Bringing DataOps to Power BI” is up:
bit.ly/3F4DyQp
. If you’re working with Gen1
#PowerBI
Dataflows and need to automate versioning, this article may be of help (especially for Government Community Cloud teams).
loading . . .
Part 33: Bringing DataOps to Power BI
Make It Reproducible… for Gen1 Dataflows
https://bit.ly/3F4DyQp
about 2 years ago
0
0
0
Awesome post by
@mmarie.bsky.social
with parametrizing notebooks in Databricks. Parameterizing your data pipelines is a critical aspect of DataOps. So if your trying to improve delivery and reduce manual work in Databricks, keep Meagan's blog bookmarked for great tips.
add a skeleton here at some point
about 2 years ago
0
2
0
you reached the end!!
feeds!
log in