Skip to main content

Microsoft Power BI Component

Microsoft Power BI

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 a raw HTTP request to Power BI API | key: rawRequest

Update Table​

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