Is this you? As a journalist, you can create a free Muck Rack account to customize your profile, list your contact preferences, and upload a portfolio of your best work.
Claim your profile
Articles by John Kerski
How to secure API keys in Microsoft Fabric Gen2 dataflows with Azure Key Vault
If you’ve ever developed a Gen1 dataflow to connect to an external API (Application Programming Interface), you know the awkward moment when you have to paste an API key into the Power Query script. There it sits, in plain text, inside an artifact (the proper name for something like a semantic model, report or dataflow created in the service), with limited options for secret rotation or .
How to secure API keys in Microsoft Fabric Gen2 dataflows with Azure Key Vault
If you’ve ever developed a Gen1 dataflow to connect to an external API (Application Programming Interface), you know the awkward moment when you have to paste an API key into the Power Query script. There it sits, in plain text, inside an artifact (the proper name for something like a semantic model, report or dataflow created in the service), with limited options for secret rotation or .
Power BI Project (PBIP) is now generally available. Here’s why that matters – and how it works
Do you know where you were on June 15, 2023? Do not fret, neither do I. But I do remember a blog post written by Rui Romano announcing the preview of the Power BI Project (PBIP) format back then. Many in the Power BI world rejoiced at this news. Microsoft was finally taking steps toward better practices seen in software development and applying them to the analytics space. As it happens, June 15, 2023 was just the first step.
How to use the Power BI Desktop Bridge to automate tasks in Power BI Desktop and GitHub Copilot
Microsoft continues to blur the line between low-code visual tools and code-first development for Power BI, recently launching a set of official Fabric AI Skills and the Power BI Desktop Bridge preview feature. Together, they allow AI agents to install command-line tools, inspect a running Power BI Desktop process, update a report or model in the Power BI project format (PBIP), and reload the report so that changes appear immediately.
How to use the Power BI Desktop Bridge to automate tasks in Power BI Desktop and GitHub Copilot
Microsoft continues to blur the line between low-code visual tools and code-first development for Power BI, recently launching a set of official Fabric AI Skills and the Power BI Desktop Bridge preview feature. Together, they allow AI agents to install command-line tools, inspect a running Power BI Desktop process, update a report or model in the Power BI project format (PBIP), and reload the report so that changes appear immediately.
How to automate Fabric data agent testing with promptfoo and GitHub Actions
This guide walks through setting up promptfoo, an open-source LLM testing framework, to run automated test suites against your Fabric data agent locally and inside a GitHub Actions pipeline. The result? Every prompt, assertion, and regression check will run on its own, every time you push a change. If you read my previous article on why DataOps matters in the age of AI, you already know I believe testing data agents is essential.
Never ship a broken semantic model again: how to build automated tests in Power BI with user-defined functions
User-defined functions (UDFs) in Power BI let you build reusable, automated tests for your semantic models — so you catch broken measures, duplicate rows, and faulty relationships before they reach your reports. This article walks through how to use UDFs alongside PQL.Assert to standardize testing across your team, and how to automate those tests with Power Automate or a Fabric Notebook. Reuse is a very important term in DataOps.
Never ship a broken semantic model again: how to build automated tests in Power BI with user-defined functions
User-defined functions (UDFs) in Power BI let you build reusable, automated tests for your semantic models — so you catch broken measures, duplicate rows, and faulty relationships before they reach your reports. This article walks through how to use UDFs alongside PQL.Assert to standardize testing across your team, and how to automate those tests with Power Automate or a Fabric Notebook. Reuse is a very important term in DataOps.
How DataOps principles help to reduce GenAI risk and improve data quality
John Kerski explains how DataOps principles improve trust, quality, and governance when using GenAI in data solutions. Includes John’s advice on how to apply these principles – plus tips for Git, testing, Microsoft Fabric, and more. Over the past three years, the presence of Generative Artificial Intelligence (GenAI) in the world of data has how we build solutions.
Power BI TMDL View: Benefits, Security Risks & Best Practices
The Tabular Model Definition Language (TMDL) provides a simpler way of defining Power BI Semantic Models. Unlike the JSON-based Tabular Model Scripting Language (TMSL), TMDL uses a more accessible tab-based format for specifying DAX measures, relationships, and Power Query code. In January 2025, Microsoft introduced the TMDL View, which makes it easier for pro-code developers who use conventional programming languages with semantic models to share and reuse TMDL.
The Tabular Model Definition Language (TMDL) provides a simpler way of defining Power BI Semantic Models. Unlike the JSON-based Tabular Model Scripting Language (TMSL), TMDL uses a more accessible tab-based format for specifying DAX measures, relationships, and Power Query code. In January 2025, Microsoft introduced the TMDL View, which makes it easier for pro-code developers who use conventional programming languages with semantic models to share and reuse TMDL.
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 and quickly create PivotTables. Then, when Power Query appeared in Power BI, I began working with larger data sources and more complex projects. Through many trials and tribulations, I learned the capabilities of Power Query and the M language (the functional language that actually transforms our data), as well as its idiosyncrasies.
Power BI TMDL View: Benefits, Security Risks & Best Practices
The Tabular Model Definition Language (TMDL) provides a simpler way of defining Power BI Semantic Models. Unlike the JSON-based Tabular Model Scripting Language (TMSL), TMDL uses a more accessible tab-based format for specifying DAX measures, relationships, and Power Query code. In January 2025, Microsoft introduced the TMDL View, which makes it easier for pro-code developers who use conventional programming languages with semantic models to share and reuse TMDL.
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 and quickly create PivotTables. Then, when Power Query appeared in Power BI, I began working with larger data sources and more complex projects. Through many trials and tribulations, I learned the capabilities of Power Query and the M language (the functional language that actually transforms our data), as well as its idiosyncrasies.
The complexity of using Power BI in US Sovereign Clouds
“I hate to tell you this, but it’s not available for us yet.” This is an all-too-common phrase I find myself saying to customers in U.S. Sovereign Cloud tenants who come across new features in search engine results only to find they’re not available in our regions. For those unfamiliar, U.S. Sovereign Cloud regions allow U.S. government, public sector, and other highly regulated entities to use the cloud with the security, compliance, and data sovereignty required by their organizations.
Comparing Groups for Similarities in Power Query - Using Cosine Similarity
I’ll admit upfront—I am not a data scientist by trade. Instead, I’ve picked up my data science skills over time, learning through a combination of osmosis from talented colleagues and tackling real-world data challenges. It’s been a journey of trial, error, and refinement, as I’ve worked to bridge gaps between complex data science techniques and tools available to me.
Show More
loading
Actions
Is this you?
As a journalist, you can create a free Muck Rack account to customize your profile, list your contact preferences, and upload a portfolio of your best work.Get in touch with John
Contact John, search articles and posts on X, monitor coverage, and track replies from one place.
Learn more about Muck Rack