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.

Authorization Notes#

The MS Power BI Client Id and Client Secret can be put directly into an Oauth2 credential.

Actions#

Create Dataset#

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

InputKeyNotesExample

Columns

string
/ Required
columnsFor each item, provide an object containing the column name and data type.{ "name": "ProductID", "dataType": "Int64" }

Dataset Name

string
/ Required
datasetNameProvide a string value for the name of the database you want to interact with.MyDatabase

Table Name

string
/ Required
tableName

Authorization#

Authorization is required for this action.
Auth TypeKeyDescriptionFields
OAuth 2.0 - Authorization Codeoauth2OAuth 2.0 authorization using the authorization code grant type

Client ID |  client_id

Client Secret |  client_secret

Scopes |  scopes

Authorization URL |  auth_uri

Access Token URL |  token_uri


Create Row#

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

InputKeyNotesExample

Dataset ID

string
/ Required
datasetIdA dataset is a spreadsheet like document that can be used to generate reports and visuals in Power BI.myExampleDataset

Rows

data
/ Required
rowsFor each item, provide an object containing the fields to be inserted.{ "ProductID": 1, "Name": "Adjustable Race", "Category": "Components", "ManufacturedOn": "07/30/2014" }

Table Name

string
/ Required
tableName

Authorization#

Authorization is required for this action.
Auth TypeKeyDescriptionFields
OAuth 2.0 - Authorization Codeoauth2OAuth 2.0 authorization using the authorization code grant type

Client ID |  client_id

Client Secret |  client_secret

Scopes |  scopes

Authorization URL |  auth_uri

Access Token URL |  token_uri


Delete Rows#

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

InputKeyNotesExample

Dataset ID

string
/ Required
datasetIdA dataset is a spreadsheet like document that can be used to generate reports and visuals in Power BI.myExampleDataset

Table Name

string
/ Required
tableName

Authorization#

Authorization is required for this action.
Auth TypeKeyDescriptionFields
OAuth 2.0 - Authorization Codeoauth2OAuth 2.0 authorization using the authorization code grant type

Client ID |  client_id

Client Secret |  client_secret

Scopes |  scopes

Authorization URL |  auth_uri

Access Token URL |  token_uri


List Datasets#

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

Authorization#

Authorization is required for this action.
Auth TypeKeyDescriptionFields
OAuth 2.0 - Authorization Codeoauth2OAuth 2.0 authorization using the authorization code grant type

Client ID |  client_id

Client Secret |  client_secret

Scopes |  scopes

Authorization URL |  auth_uri

Access Token URL |  token_uri


List Groups#

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

Authorization#

Authorization is required for this action.
Auth TypeKeyDescriptionFields
OAuth 2.0 - Authorization Codeoauth2OAuth 2.0 authorization using the authorization code grant type

Client ID |  client_id

Client Secret |  client_secret

Scopes |  scopes

Authorization URL |  auth_uri

Access Token URL |  token_uri


List Reports#

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

Authorization#

Authorization is required for this action.
Auth TypeKeyDescriptionFields
OAuth 2.0 - Authorization Codeoauth2OAuth 2.0 authorization using the authorization code grant type

Client ID |  client_id

Client Secret |  client_secret

Scopes |  scopes

Authorization URL |  auth_uri

Access Token URL |  token_uri


List Tables#

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

InputKeyNotesExample

Dataset ID

string
/ Required
datasetIdA dataset is a spreadsheet like document that can be used to generate reports and visuals in Power BI.myExampleDataset

Authorization#

Authorization is required for this action.
Auth TypeKeyDescriptionFields
OAuth 2.0 - Authorization Codeoauth2OAuth 2.0 authorization using the authorization code grant type

Client ID |  client_id

Client Secret |  client_secret

Scopes |  scopes

Authorization URL |  auth_uri

Access Token URL |  token_uri


Update Table#

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

InputKeyNotesExample

Columns

string
/ Required
columnsFor each item, provide an object containing the column name and data type.{ "name": "ProductID", "dataType": "Int64" }

Dataset ID

string
/ Required
datasetIdA dataset is a spreadsheet like document that can be used to generate reports and visuals in Power BI.myExampleDataset

Table Name

string
/ Required
tableName

Authorization#

Authorization is required for this action.
Auth TypeKeyDescriptionFields
OAuth 2.0 - Authorization Codeoauth2OAuth 2.0 authorization using the authorization code grant type

Client ID |  client_id

Client Secret |  client_secret

Scopes |  scopes

Authorization URL |  auth_uri

Access Token URL |  token_uri