Control-M for Microsoft 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.

  • Introduce all Control-M capabilities to Control-M for Microsoft Power BI, including advanced scheduling criteria, complex dependencies, resource pools, lock resources, and variables.

  • 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.

  • Attach an SLA job to the Microsoft Power BI jobs.

  • Run 50 Microsoft Power BI jobs simultaneously per Agent.

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 KA000437809.

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 Microsoft Power BI job in Control-M SaaS and Automation API.

Before You Begin

  • Register your client application with Azure Active Directory (Azure AD).

  • Add API permissions to the client application in the Azure Portal.

  • Disable multi-factor authentication (MFA) for username and password authentication in the Azure Portal.

  • Enable service principal authentication in the Power BI settings.

  • 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_directory>

      • csh/tcsh: setenv BMC_INST_JAVA_HOME <java_directory>

    • Windows: set BMC_INST_JAVA_HOME="<java_directory>"

  2. Do one of the following:

    • Install: Run one of the following provision image commands:

      • Linux: ctm provision image MBI_plugin.Linux

      • Windows: ctm provision image MBI_plugin.Windows

    • Upgrade: Run the following command:

      ctm provision agent::update

  3. Create a Microsoft Power BI connection profile in Control-M SaaS or Automation API, as follows:

  4. Define a Microsoft Power BI job in Control-M SaaS or Automation API, as follows:

To remove this plug-in from an Agent, see Removing a Plug-in. The plug-in ID is MBI042022.

Change Log

The following table provides details about changes that were introduced in new versions of this plug-in:

Plug-in Version

Details

1.0.05

  • Added Enhanced Dataset Refresh to Power BI job

  • Changed default values for the following:

    • Connection Timeout

    • Status Polling Frequency

1.0.04

Menu divided menu for dual functionality

1.0.03

Change in API usage to run refresh once without admin

1.0.02

Failure tolerance added

1.0.01

Icon change

1.0.00

Initial version