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.

Setting Up Power BI in Azure

To enable proper function of the Control-M for 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 Power BI

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

Before You Begin

  • Verify that Automation API is installed, as described in Setting up the API.
  • Verify that Control-M/Agent 9.0.21.200 or higher is installed.
  • Verify that Application Integrator 9.0.21.200 or higher is installed.

Begin

  1. On the Agent host, run one of the following commands to set the Java environment variable:
    • Linux:
      • Bourne Shell/Bash: export BMC_INST_JAVA_HOME=<java_11_directory>
      • csh/tcsh: setenv BMC_INST_JAVA_HOME <java_11_directory>
    • Windows: set BMC_INST_JAVA_HOME="<java_11_directory>"
  2. Run one of the following API commands:
    • To create a fresh installation, run one of the following provision image commands:
      • 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
    • To upgrade, run the following command:
      ctm provision agent::update
  3. Create a Power BI connection profile in Helix Control-M or Automation API, as follows:
  4. Define a Power BI job in Helix Control-M 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