CertyFAST v1.1.0

CertyFAST by MAQ Software v1.1.0

Streamlining Power BI model development with automated error detection, DAX measure formatting, and simplified documentation, ensuring top-notch quality and adherence to best practices in enterprises.

Change Log

1. Support for additional file types (TMDL, XMLA Endpoint)
2. Enhancements to lineage view
3. Walkthrough screens for new users

What's New:

1. Support for additional file types

   1. Semantic Model Analysis
      1. TMDL - Select the TMDL root folder containing semantic model definition. The folder needs to follow TMDL structure and folder name should follow the naming convention of ReportName.SemanticModel
      2. XMLA Endpoint - Provide XMLA connection string for your workspace and click on connect. After authentication, list of semantic models present in the workspace will be listed in the dropdown
   2. Report UI Analysis
      1. Report Folder - Select the folder containing all the reports (pbix file) connected to a single semantic model. This option enables project teams to perform report analysis for all the report together and get accurate information about the fields and measures not used in any of the report. All the tool features will show datapoints from all the reports.

2. Lineage view enhancements

   1. Field Parameters and Calculated Tables - Team members can now easily visualize the fields used to create a field parameter or calculated table. It also enables an easy view to understand the visuals making use of field parameters

      

   2. Grid view - Switch to grid view to understand the impact of a certain field in a simple tabular information. Filter to a specific field which you are looking for and get details of all the objects used to create the field or the objects which uses the selected field.

      

   3. Highlight unused fields - Identify unused fields (columns and measures) directly from the lineage view by clicking on the View Unused Objects checkbox. Once the checkbox is selected, all the fields not used in your model are highlighted for easy identification of users.

      

   4. Layout ordering - Changed the ordering of connecting semantic model fields to the visual to remove redundant page nodes and make it easy for users to understand the lineage. Now, columns/measures will be directly connected to the visual nodes where they are used, and all the visual nodes will connect to respective page node

      

3. Documentation enhancements

   1. Added field parameter value for table type column to easily identify the tables auto created as part of field parameters
   2. Added source details information to surface the upstream source type along with server/file details and tables used in the query.

   

   Note - Currently, we support limited sources for accurate identification of source information and we will be enhancing the list in future releases.