Power BI Dataset Refresh Integration: AutoSys Workload Automation

Products

• Autosys Workload Automation

Issue/Introduction

 This article provides instructions to integrate AutoSys Workload Automation with Microsoft Power BI to schedule, execute, and monitor dataset refreshes.
This integration utilizes the Azure Power BI Plugin Extension (POJO-based) to interact with Power BI REST APIs, supporting unified analytics environments such as Microsoft Fabric.

Environment

• AutoSys Workload Automation AE r12.x or r24.x
• Workload Automation System Agent r12.x or r24.x
• Azure Power BI / Microsoft Fabric

Resolution

AutoSys utilizes the Azure Power BI Plugin Extension to communicate with Power BI cloud endpoints via the POJO job type.

Prerequisites:

1. Download the Power BI Plugin Extension from the Broadcom Automation Marketplace.
2. Install the Workload Automation System Agent on the server designated to make outbound calls to Azure/Power BI cloud endpoints.

Installation:

1. Use the PluginInstaller utility on the System Agent to install the Plugin.Extension.Azure.PowerBI package.
2. Confirm the plugin is installed on the AutoSys System Agent.
   Use the cybAgent -vv command to confirm the plugin is installed

Job Definition (JIL): 
Define an AutoSys job using the POJO job type.
When using POJO jobs, the JIL must match the example order and fields; no fields can be omitted.

Example JIL Configuration:

insert_job: powerbi_refresh_job
job_type: POJO
machine: <AGENT_NAME>
method_name: triggerDatasetRefresh
class_name: com.broadcom.pojo.powerbi.PowerBIPojo
j2ee_parameter: powerbi.Endpoint="https://api.powerbi.com/v1.0/myorg"
j2ee_parameter: powerbi.ClientId=####
j2ee_parameter: powerbi.ClientSecret=####
j2ee_parameter: powerbi.WorkspaceName="<WORKSPACE_NAME>"
j2ee_parameter: powerbi.DatasetName="<DATASET_NAME>"

Additional Information

• For detailed usage and video explanations, see the  Workload Automation Plugin Extensions - Power BI Plugin Extension
• To speak with a customer representative or a Support Engineer, see Contact Support. Scroll to the bottom of the page and click on your respective region.