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
- 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>"
- Linux:
- 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
- Linux:
- To upgrade, run the following command:
ctm provision agent::update
- To create a fresh installation, run one of the following provision image commands:
- Create a Power BI connection profile in Helix Control-M or Automation API, as follows:
- Helix Control-M: Create a Centralized Connection Profile with one of the following relevant parameters:
- Automation API: Create a centralized connection profile with one of the following relevant parameters:
- Define a Power BI job in Helix Control-M or Automation API, as follows:
- Helix Control-M: Create a Job with one of the following relevant parameters:
- Automation API: Create a Job with one of the following relevant parameters:
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 |
|
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*