Skip to main content

Microsoft Power BI Component

Interact with and modify Power BI datasets

Component key: ms-power-bi

Description

Microsoft Power BI is a Microsoft data visualization and business analytics service. This component allows you to interact with datasets and update data schemas.

Connections

OAuth 2.0

The Microsoft Power BI component authenticates requests through the Microsoft Graph API. To configure OAuth 2.0 you must first create an application through Active Directory in the Microsoft Azure portal. For more information regarding authenticating against the Microsoft Graph API refer to Microsoft's documentation.

Next, supply the following values to the OAuth 2.0 connection in your integration within Prismatic:

  • For Client ID and Client Secret enter the values that you got from the Microsoft Azure Portal.
  • For Scopes choose from the options found on the Microsoft Graph API documentation
  • For Authorize URL and Token URL you will need to identify your Azure Tenant ID to include in the URLs or configure your app for multi-tenant which allows using the common endpoints.

Refer to the Microsoft Power BI REST API documentation for more information.

Actions

Create Dataset

Creates a new dataset on 'My Workspace' | key: createDataset


Create Rows

Adds new data rows to the specified table within the specified dataset from 'My Workspace' | key: createRow


Delete Rows

Deletes all rows from the specified table within the specified dataset from 'My Workspace' | key: deleteRows


List Datasets

Returns a list of datasets from 'My Workspace' | key: listDatasets


List Groups

Returns a list of workspaces the user has access to | key: listGroups


List Reports

Returns a list of reports from 'My Workspace' | key: listReports


List Tables

Returns a list of tables tables within the specified dataset from 'My Workspace' | key: listTables


Raw Request

Send raw HTTP request to Microsoft Power BI | key: rawRequest


Update Table

Updates the metadata and schema for the specified table within the specified dataset from 'My Workspace' | key: updateTable