Power BI Actions XPLAT

This tasks does more or less the same as the Power BI Actions tasks. This task is also able to un on linux agents.

Power BI Actions is a task for Azure Pipelines. With this tasks you can automate specific tasks for Power BI.

The following tasks can be automated by using this extension:

• Upload / Import Power BI dashboard (pbix file).
• Upload / Import Power BI dashboard and skip report (pbix file).
• Create a Power BI workspace.
• Remove a Power BI workspace.
• Add a new Admin user to a Power BI workspace.
• Add a Service Principal to a Power BI workspace.
• Add a Group to a Power BI workspace.
• Update the connection of a Power BI report.
• Refresh a dataset.
• Update SQL Direct Query String
• Update Gateway
• Set a specific capacity for a workplace
• Rebind Report
• Set Refresh Schedule
• Set Dataset Permissions

The following organization types are supported from version 5 and higher:

• Commercial (Public)
• Microsoft 365 Government Community Cloud (US)
• Microsoft 365 Government Community Cloud High (US)
• US Department of Defense
• Microsoft Cloud China
• Microsoft Cloud Germany

The task works with a "Power BI" service connection that needs to be configured within the "Service Connections" settings of the project. From version 5 there is one single service connections. In this service connection you can choose between "Username/Password" and "Service Principal" authentication.

Username/Password

For the service connection to work with a Username password combination you need to configure the following parameters:

• Username: The username of the user that will perform the actions. Make sure the account does not have Multi Factor authentication enabled.
• Password: The password of the user.

Note: The user must have a Power BI Pro license in order to perform the tasks.

Service Principal

To configure a Service Principal with PowerBI you will have to go through this guide:

Service principal with Power BI

• ClientId: The client id of the Azure Active Directory application. This application should have the appropriate rights in order to use the Power BI Api.
• ClientSecret: The client secret of the application
• Tenant ID: The identifier of the Azure Active Directory tenant

Output

During the execution of the task different values will be placed inside variables:

• PowerBIActions.ReportId: The report Id of the uploaded report (only supported when uploading one report).
• PowerBIActions.WorkspaceId: The Id of the workspace.

Documentation

For the documentation check the wiki.

If you like the extension, please leave a review. File an issue when you have suggestions or if you experience problems with the extension.

Issues

Release Notes