How to use IBM App Connect with Microsoft Power BI

Connecting to Microsoft Power BI

Complete the connection fields that you see in the App Connect Designer Connect > Applications and APIs page or flow editor. If necessary, work with your Microsoft Power BI administrator to obtain these values.

Microsoft Power BI connection fields:

To obtain the connection values for Microsoft Power BI, see Obtaining connection values for Microsoft Power BI.

To connect to a Microsoft Power BI endpoint from the App Connect Designer Applications and APIs page for the first time, expand Microsoft Power BI, then click Connect. For more information about ways to connect to Microsoft Power BI, see Managing accounts in App Connect.

General considerations

Before you use App Connect Designer with Microsoft Power BI, take note of the following considerations:

• To control the Microsoft Power BI features that are made available to your organization, see Tenant settings on the Microsoft Documentation page.
• If you would like to use Admin API, see Developer tenant settings on the Microsoft Documentation page.
• To use service principals to use read-only Microsoft Power BI admin APIs, see Admin API tenant settings on the Microsoft Documentation page.
• (General consideration) You can see lists of the trigger events and actions that are available on the Applications and APIs page of the App Connect Designer.

  For some applications, the events and actions depend on the environment and whether the connector supports configurable events and dynamic discovery of actions. If the application supports configurable events, you see a Show more configurable events link under the events list. If the application supports dynamic discovery of actions, you see a Show more link under the actions list.

• (General consideration) If you are using multiple accounts for an application, the set of fields that is displayed when you select an action for that application can vary for different accounts. In the flow editor, some applications always provide a curated set of static fields for an action. Other applications use dynamic discovery to retrieve the set of fields that are configured on the instance that you are connected to. For example, if you have two accounts for two instances of an application, the first account might use settings that are ready for immediate use. However, the second account might be configured with extra custom fields.

Events and actions

Microsoft Power BI events

These events are for changes in this application that trigger a flow to start completing the actions in the flow.

Microsoft Power BI actions

Your flow completes these actions on this application.

Datasets

Retrieve datasets

Retrieve dataset gateways

Retrieve dataset user access

Retrieve dataset to dataflow links

Delete dataset

Add dataset user

Update dataset

Update dataset user access

Refresh dataset

Bind to gateway

Gateway data sources

Create gateway data source

Retrieve gateway data sources

Update gateway data source

Delete a gateway data source

Goals

Create goal

Create goal values

Retrieve goals

Retrieve goal values

Update goal

Update goal values

Delete goal

Delete a goal values

Delete current goal value connection

Delete current target value connection

Refresh current goal value

Refresh current target value

Push datasets

Retrieve tables

Delete rows

Update table

Insert multiple rows

Workspaces

Create workspace

Retrieve workspace users

Retrieve workspaces

Add workspace user

Delete workspace

Update workspace user

Remove workspace user