Skip to Content

Control-M for Power BI

Microsoft Power BI jobs enable you to run workflows for data visualization.

Control-M for Microsoft Power BI enables you to do the following:

  • Execute Microsoft Power BI jobs that run a Data Refresh or Pipeline Deployment, which can sync development, test, and production workspaces.
  • Manage Power BI credentials in a secure connection profile.
  • Connect to any Power BI endpoint.
  • Integrate Microsoft Power BI jobs with other Control-M jobs into a single scheduling environment.
  • Monitor the status, results, and output of Microsoft Power BI jobs in the Monitoring domain.
  • Attach an SLA job to your Microsoft Power BI jobs.
  • Introduce all Control-M capabilities to Control-M for Microsoft Power BI including advanced scheduling criteria, complex dependencies, Resource Pools, Lock Resources, and variables.
  • Run 50 Microsoft Power BI jobs simultaneously per Agent.
  • For Microsoft Power BI SP only: Authenticate applications with service principal authentication.

Control-M for Microsoft Power BI Compatibility

Control-M for Microsoft Power BI supports integration with the Power BI Cloud (SaaS) solution, but not with Power BI on-premises solution.

The following table lists the prerequisites that are required to use the Microsoft Power BI plug-in, each with its minimum required version.

Component

Compatibility Version for Microsoft Power BI

Compatibility Version for Microsoft Power BI SP

Control-M/EM

9.0.20.200

9.0.21.200

Control-M/Agent

9.0.20.200

9.0.21.200

Control-M Application Integrator

9.0.20.201

9.0.21.200

Control-M Automation API

9.0.20.250

9.0.21.200

Control-M for Microsoft Power BI is supported on Control-M Web and Control-M Automation API, but not on Control-M client.

To download the required installation files for each prerequisite, see Obtaining-Control-M-Installation-Files.

Setting Up Microsoft Power BI in Azure

To enable proper function of the Control-M for Microsoft Power BI plug-in, you must perform several setup tasks in Azure. These tasks are described in Setting-Up-for-Power-BI-in-Azure.

Setting Up Control-M for Microsoft Power BI

This procedure describes how to deploy the Microsoft Power BI plug-in, create a connection profile, and define a Power BI job in Control-M Web and Automation API.

Warning

Note

Integration plug-ins released by BMC require an Application Integrator installation. However, these plug-ins are not editable and you cannot import them into Application Integrator. To deploy these integrations to your Control-M environment, import them directly into Control-M using Control-M Automation API.

Before You Begin

Begin

  1. Create a temporary directory to save the downloaded files.
  2. Download the relevant plug-in from one of the following download pages in the EPD site:
  3. Install the Microsoft Power BI plug-in via one of the following methods:
    • (9.0.21 or higher) Use the Automation API Provision service:
      1. Log in to the Control-M/EM Server machine as an Administrator and store the downloaded zip file in the one of following locations (within several minutes, the job type appears in Control-M Web):
        • Linux: $HOME/ctm_em/AUTO_DEPLOY
        • Windows: <EM_HOME>\AUTO_DEPLOY
      2. Log in to the Control-M/Agent machine and run one of the following provision image commands, as follows:
        • Linux:
          • (Microsoft Power BI) ctm provision image MBI_plugin.Linux
          • (Microsoft Power BI SP) ctm provision image Microsoft_Power_BI_SP_plugin.Linux
        • Windows:
          • (Microsoft Power BI) ctm provision image MBI_plugin.Windows
          • (Microsoft Power BI SP) ctm provision image Microsoft_Power_BI_SP_plugin.Windows
    • (9.0.20.200 or lower) Use the Automation API Deploy service, as described in deploy jobtype.
  4. Create a Power BI connection profile in Control-M Web or Automation API, as follows:
  5. Define a Microsoft Power BI job in Control-M Web or Automation API, as follows:
Warning

Note

To remove this plug-in from an Agent, see Removing a Plug-in. The plug-in ID for Microsoft Power BI is MBI042022, and for Microsoft Power BI SP is PBI082024.

Change Log

The following table provides details about changes that were introduced in new versions of the Microsoft Power BI SP plug-in:

Plug-in Version

Details 

1.0.00

Initial release.

1.0.01

  • Fix in dataflow tracking 
  • Abort option added for dataflow

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

Control-M