Test Automation for Power BI
The most comprehensive testing automation solution for Microsoft Power BI Tool.
BI Validator will start supporting test automation of Power BI from the July, 2020 release
Power BI Testing Key Features & Benefits
Automate Functional, Regression and Report Testing of Power BI Workspaces, Reports, Pages & Visuals.
Workspaces Testing
Description comes here
Functional Testing
Map and compare report data with data from database query to validate the reports.
Report Testing
Description comes here
Visuals Testing
Baseline and compare data of visuals to identify data differences.
Enterprise Collaboration
Test Plans and Test Plans results are shared between team. 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 Power BI REST API and Javascript API to making it easy to automate BI testing. It uses the Power BI 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 Power BI 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 Power 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 worksheet 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.
BI Validator Resources
Try BI Validator free for 30 days or contact us for demo.
