pql-assert

Validate DAX data, calculations, and model integrity in Power BI.

1|Updated Feb 13, 2026
One-click install
npx skills add https://github.com/clientfirsttech/power-query-lint-vs-code-extension --skill pql-assert
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: pql-assert
Source: https://github.com/clientfirsttech/power-query-lint-vs-code-extension/tree/main/skills/pql-assert
Command: npx skills add https://github.com/clientfirsttech/power-query-lint-vs-code-extension --skill pql-assert

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

PQL.Assert provides a robust framework for validating DAX computations, data quality, and model integrity in Power BI and Analysis Services by offering standardized assertion functions and discovery utilities.

Core Features & Use Cases

  • PQL.Assert functions cover a wide range of validations for values, columns, tables, relationships, and DAX expressions.
  • Test discovery and environment filtering enable scalable test management across DEV, TEST, PROD, and ANY.
  • Best practice validations help enforce model health and maintainability.

Quick Start

Install and load the PQL.Assert library into your semantic model and start writing tests using its assertion functions.

Frequently Asked Questions about pql-assert

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I write DAX unit tests for Power BI calculations?

You can write DAX unit tests by loading assertion functions into your semantic model to validate data, calculations, and relationships. This exposes standard 4-column results (TestName, Expected, Actual, Passed) for structured QA workflows.

What is the best way to validate data integrity in Analysis Services models?

Validating data integrity in Analysis Services models is best achieved through structured assertion functions that check values, columns, tables, and relationships. This enforces model health and maintainability using best-practice validations.

Can I filter DAX test discovery by environment across DEV, TEST, and PROD?

Yes, you can filter DAX test discovery by environment. The framework supports environment-aware testing, allowing you to execute scalable test management workflows specifically across DEV, TEST, PROD, and ANY contexts.

Does PQL.Assert work with Power BI and Analysis Services for model governance?

PQL.Assert works with both Power BI and Analysis Services for model governance. It provides dedicated best-practice checks and comprehensive validations to ensure robust computation accuracy and semantic model health.

What assertions are available for testing DAX expressions and table relationships?

Available assertions for testing DAX expressions and table relationships cover a wide range of validations for values, columns, tables, and calculations. These functions enable repeatable QA workflows and structured test discovery.

Why do I need unit testing for my Power BI semantic models?

You need unit testing for Power BI semantic models to validate DAX computations and prevent data quality issues. Standardized assertion functions provide repeatable QA workflows, ensuring model integrity and maintainability across development environments.