๐๐ง๐ฅ๐จ๐๐ค๐ข๐ง๐ ๐๐ข๐ฌ๐๐ฉ๐ฌ: ๐๐ฎ๐ญ๐จ๐ฆ๐๐ญ๐ข๐ง๐ ๐๐ข๐ฌ๐ฎ๐๐ฅ ๐๐๐ฒ๐๐ซ ๐๐๐ฌ๐ญ๐ข๐ง๐ ๐ข๐ง ๐๐จ๐ฐ๐๐ซ ๐๐ ๐ฐ๐ข๐ญ๐ก ๐๐๐ ๐๐ง๐ฌ๐ฉ๐๐๐ญ๐จ๐ซ๐
Does the term ๐๐ข๐ฌ๐๐ฉ๐ฌ sound familiarโโ like DevOps, MLOps and DataOps...
โ
This is the term used to ensure that the BIย visuals and graphic elements on report pages are consistent, performance-optimized, and accessible before publication.
โจImplementing the CI/CD process for with Power BI project files (PBIP), through the ๐
๐๐๐ซ๐ข๐, ๐๐ข๐ญ ๐๐ง๐ ๐๐ณ๐ฎ๐ซ๐ ๐๐๐ฏ๐๐ฉ๐ฌ ๐ข๐ง๐ญ๐๐ ๐ซ๐๐ญ๐ข๐จ๐ง, involves performing a series of development quality controls before each deployment.
For this, we can harness the power of open-source community tools, such as:
๐๐๐๐๐ฎ๐ฅ๐๐ซ ๐๐๐ข๐ญ๐จ๐ซ and ๐๐๐ฌ๐ญ ๐๐ซ๐๐๐ญ๐ข๐๐ ๐๐ฎ๐ฅ๐๐ฌ for verification tests and best practice rules on dataset metadata
๐๐๐๐ ๐๐ง๐ฌ๐ฉ๐๐๐ญ๐จ๐ซ for testing the visual side, and ensuring compliance with report design rules.
โจโจโจโจโจโจโจโจ๐๐๐ ๐๐ง๐ฌ๐ฉ๐๐๐ญ๐จ๐ซโจโจโจโจโจโจโจโจโจ
โ
With the new PBIP for managing the life cycle of Power BI reports, a tool for automating visual presentation testing seems necessary.
โ
๐๐๐ ๐๐ง๐ฌ๐ฉ๐๐๐ญ๐จ๐ซ (by Nat Van Gulck) is a rule-based visual testing tool for Power BI, ideal for both desktop and CI/CD pipelines. It works with PBIP and PBIX files, offering results in HTML, JSON, or Azure DevOps logs.
โ
๐๐๐ ๐๐ง๐ฌ๐ฉ๐๐๐ญ๐จ๐ซ allows you to define fully configurable test rules (written in JSON)๐๐
For example, you can easily set rules to check the consistency of charts across report pages and receive a list of visuals that require attention, as shown in the screenshot below๐๐
๐The tool and the rules used are avalable in GitHub, check here:
https://lnkd.in/eG4cZjAt
๐For the complete Power BI pipeline process (CI/CD), to apply quality checks to reports before they go live, using Tabular Editor and Best Practice Rules for dataset metadata and using PBI Inspector for report design rules, see here: https://lnkd.in/efcwSmG7