ModelOp Center collects and persists detailed metadata about every model across the entire life cycle, from inception to production usage through continuous improvement in order to Govern the models. With all of that data, one challenge is to make the data visible and consumable in dashboards that can represent these key Model KPIs. Some of these KPIs include: What kinds of models are developed in your business? How many of those models are eventually delivering business value? What are the impacts of these models on your runtime environments?

ModelOp Center integrates with Power BI to allow enterprises to leverage their existing BI tools to create custom reports that can be shared via existing methods.

Power BI provides connectivity to external data sources through a custom Power Query Connector, allowing Power BI clients to load data from ModelOp Center.

ModelOp Center contains a package with the Power BI Connector file. Please contact your ModelOp representative to get the latest version.

These installation instructions assume the following:

• Power BI Desktop is installed. https://powerbi.microsoft.com/en-us/desktop/

• Your ModelOp Center instance is accessible from the machine on which Power BI Desktop is installed.

To enable use of the connector in Power BI Desktop:

1. The Power BI Connector has a mez or pqx file extension. Copy this file into [Documents]/Power BI Desktop/Custom Connectors. You may need to create these directories if they do not already exist.

   Open

   

    

2. Check the option (Not Recommended) Allow any extension to load without validation or warning in Power BI Desktop (under File | Options and settings | Options | Security | Data Extensions).

   Open

   

    

3. Restart Power BI Desktop. There should now be an option to use ModelOp Data as a data source (under Get Data | More | Other).

   Open

   

    

   Open

   

    

4. Upon selecting ModelOp Data, you will be prompted for the URL used to access your instance of ModelOp Center. This example assumes the ModelOp Center instance is accessible at https://my.modelop.example/.

   Open

   

    

5. Clicking OK will open another prompt to select an authentication method. To access an OAuth2-protected instance, select Organizational Account | Sign In, then proceed to login using your ModelOp Center credentials.

   Open

   

    

   Open

   

   
   Upon successful login, Power BI Desktop will securely store an access token on your local machine and associate it with the ModelOp Center instance.

   Open

   

   Prompt indicating successful login

    

6. Click Connect to begin building reports in Power BI Desktop.

   Open

   

    

To begin authoring a report, select any tables required and click Load.

Open

The ModelOp Data Connector uses the ModelOp Center REST API to expose structured data as tabular views. Table columns follow a naming convention that reflect the structure or hierarchy of each resource.

Open

DeployableModels and StoredModels tables

For an optimal experience, avoid importing tables that are unnecessary for a particular report.

In scenarios where a report depends on many tables, Power BI Desktop may erroneously detect relationships where they should not exist. Be sure to double check which relationships are detected and/or missing when working with many tables in a single report.

Open

Example of a misleading auto-detected relationship

The Power BI data connector includes a built-in backward compatibility feature that allows it to transform the current (new) metadata.custom format into the deprecated legacy format used in version 3.3.1 and earlier.

This capability is particularly valuable when working with existing reports originally built using the older metadata.custom structure (from version 3.3.1 or prior). It ensures that legacy reports remain fully functional without requiring immediate migration or rework, preventing potential compatibility issues during data refresh or import.

In the connector's user interface, users can explicitly choose the metadata format to apply:

• Current — This is the default option, aligned with the latest connector specifications and recommended for new developments.

• 3.3.1 - Version (Deprecated) — Select this when connecting to or refreshing data for reports created with older versions to maintain compatibility (Legacy Format).

Open

When establishing a connection or importing data, a pop-up dialog appears prompting the user to select the desired metadata handling mechanism. This selection is applied during the data import process, allowing seamless integration with both modern and legacy report structures.

Recommendation: Use the legacy format only when necessary to support older reports. For new reports or when updating existing ones, prefer the current format to take advantage of ongoing improvements and future-proof your solutions.

To get error logs from the ModelOp Data Connector, please follow the next steps.

• Open Power Bi Desktop and go to Options and settings

Open

• Select Options

Open

• Select Diagnostics and then check enable trace and then select Clear Traces folder

Open

• Confirm Clear Traces folder

Open

• After cleaning traces folder , select Open crash dump/traces folder , a new window will appear pointing to the crash dump/traces folder ( keep it open )

Open

Open

• Go back to Power Bi Desktop and click OK and open the ModelOp Data Connector.

Open

• Execute the action that you want to troubleshoot and once it happens, Close the error message ( if any ) and then Close Power BI Desktop.

• Once PowerBI has been closed, go back to the window pointing to the crash dump/traces folder, ( from step #5 ), go one folder up , and compress the Traces folder as zip.

Open

• Share with ModelOp the compressed zip folder.