ProductID

Name

IsCompete

ManufacturedOn

Sales

Adds new data rows to the specified table within the specified dataset from 'My Workspace'

Adjustable Race

LL Crankarm

HL Mountain Frame - Silver

Deletes all rows from the specified table within the specified dataset from 'My Workspace'

Returns a list of datasets from 'My Workspace'

Returns a list of workspaces the user has access to

Returns a list of reports from 'My Workspace'

Returns a list of tables tables within the specified dataset from 'My Workspace'

Send raw HTTP request to Microsoft Power BI

Updates the metadata and schema for the specified table within the specified dataset from 'My Workspace'

The Microsoft Power BI component authenticates requests through the Microsoft Graph API.
To configure OAuth 2.0 you must first [create an application](https://docs.microsoft.com/en-us/power-bi/developer/embedded/register-app?tabs=customers%2CAzure) through Active Directory in the Microsoft Azure portal.
For more information regarding authenticating against the Microsoft Graph API refer to [Microsoft's documentation](https://docs.microsoft.com/en-us/power-bi/developer/automation/walkthrough-push-data-get-token).

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](https://docs.microsoft.com/en-us/graph/permissions-reference)
-   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](https://docs.microsoft.com/en-us/rest/api/power-bi/) for more information.


Interact with and modify Power BI datasets

[Microsoft Power BI](https://www.microsoft.com/en-us/sql-server) is a Microsoft data visualization and business analytics service.
This component allows you to interact with datasets and update data schemas.


Action Name	Action Description
List Groups	Returns a list of workspaces the user has access to
List Datasets	Returns a list of datasets from 'My Workspace'
List Reports	Returns a list of reports from 'My Workspace'
List Tables	Returns a list of tables tables within the specified dataset from 'My Workspace'
Create Dataset	Creates a new dataset on 'My Workspace'
Create Rows	Adds new data rows to the specified table within the specified dataset from 'My Workspace'
Update Table	Updates the metadata and schema for the specified table within the specified dataset from 'My Workspace'
Delete Rows	Deletes all rows from the specified table within the specified dataset from 'My Workspace'
Raw Request	Send raw HTTP request to Microsoft Power BI

Microsoft Power BI Connector

Integrate with customers’ other SaaS apps, fast

About the Microsoft Power BI Connector

Actions

Triggers

Ready to get started?