Datagaps - Automated Testing Tools for ETL, BI & BigData Testing

Test Automation for Power BI

The most comprehensive testing automation solution for Microsoft Power BI Service.

BI Validator automates the testing of your Microsoft Power BI Reports, Pages, Visuals and Datasets

Key Features & Benefits

Automate the Functional, Regression and Stress testing of Microsoft Power BI Reports.

Regression Testing

Baseline and compare Power BI Reports, Pages, Visuals, Filters and Datasets using BI Validator’s Power BI test plan.

Visual Data Validation

Map and compare visual data with data from database SQL query for an end-to-end testing of your Power BI reports thus helping build trust in your data.

Stress Testing

Validate the performance of your reports by simulating concurrent user load on your Power BI service and identify pages that are not meeting your SLA.

DAX Query Validation

Coming soon – Automatically generate DAX Queries and validate reports to identify Dataset Model inconsistencies.

Row-Level Security (RLS)

BI Validator now supports the testing of Row-Level Security (RLS) by applying different Roles/Users to the reports and comparing the data.

Enterprise Collaboration

Test Plans and test results can be shared between team members. Tests can be scheduled and results emailed.

Enables Continuous Integration for BI

By automating the BI Regression and Performance testing, BI Validator enables Continuous Integration for Business Intelligence application development.

  • Integrates with Jenkins: BI Validator provides a command line interface for kicking of Test Plans. Customers have used this interface to execute tests automatically from Jenkins.
  • Email Notifications: Key stakeholders are automatically notified by email.
  • Web Reporting: BI Validator comes with out-of-the-box web reporting. Queries can be executed on the BI Validator repository for additional reporting.

Compare Report Data & UI

BI Validator is integrated with the BI Platform’s REST API and Javascript API to making it easy to automate BI testing. It uses the metadata to completely eliminate the need for custom programming.

  • Report UI & data Testing: Baseline and compare reports to automatically identify data and UI differences.
  • Filters & Parameters Testing: BI Validator automatically retrieves Filters and Parameters making it easy to test the list of values displayed in a filter as well as applying them before running the reports.
  • PDF & Image Comparison: BI Validator compares PDF exports and Image snapshots of the BI dashboard and highlights the differences intuitively.

Automated Regression Testing

Upgrade with peace by comparing Power BI dashboard performance before and after the upgrade.

  • Performance testing:BI Validator automates performance testing of Power BI dashboards by accurately measuring the time taken by Power BI bootstrap requests and tab-switch events. BI Validator further simplifies the performance recording.
  • Stress testing: The performance of the Power BI reports under concurrent user load can be tested using the stress test plan. Stress testing can be very helpful when adding new users or upgrading to a version of Power BI.

Perform End-to-end Power BI testing

BI Validator helps automate the comparison of report data with database query output thus enabling end-to-end testing of Power BI reports and dashboards.

  • Compare Report to SQL Query output: Connect to any ODBC enabled data source and compare Power BI visual data with SQL Query output from the ODBC data source.
  • BI Tool Migration testing: BI Validator makes it simple to compare the data between reports from different BI tools.
  • Compare Summary to Detail report data: Compare aggregate metrics in a summary report with data in a detail report.