Free Plan

PQL.Assert

Testing Framework for Semantic Models

Client First Technologies is dedicated to empowering data professionals with the tools they need to create better, more maintainable solutions. Last year we introduced Power Query Lint to make your Power Query better, and now we've introduced a testing framework for semantic models leveraging User Defined Functions called PQL.Assert.

Key Benefits

Framework Features

  • Housed completely within Power BI Semantic Models
  • No external dependencies required
  • Standardizes test outputs for consistency
  • Provides framework for testing with Power Automate
  • Integration with other automation tools

Testing Advantages

  • Validate semantic model calculations
  • Catch breaking changes early
  • Automated regression testing
  • Improve model reliability
  • Self-contained testing solution

Get Started with PQL.Assert

PQL.Assert is available as an open-source library. Download the package, explore the documentation, or contribute to the project on GitHub.

Want to contribute, raise issues, or download our Power Automate testing example?

Visit our GitHub repository