Microsoft Power BI is a business analytics service that delivers insights to enable fast, informed decisions. Connect to hundreds of data sources, simplify data prep, and drive ad hoc analysis.
Changelog
3 versions
v1.1.0
Latest
- Added MakeApiCall component for performing arbitrary authorized API calls to the Power BI API.
v1.0.2
- Added output port examples to all components.
v1.0.0
- Initial release.
Authentication
| Type | Details |
|---|---|
| OAuth 2 |
Authentication Hub
Verified
This connector is globally authenticated and verified by Appmixer and is ready to use without registering your own OAuth application with the provider. Appmixer's Authentication Hub acts as an authentication proxy, so all OAuth-based connectors work out of the box. You can still use your own OAuth credentials (clientId and clientSecret) for enhanced customization or compliance — see the Connector Configuration section of the documentation. The Authentication Hub is enabled for all hosted Appmixer tenants; on self-managed installations it has to be explicitly set.
Scopes:
offline_access
|
Actions
18
Create Dashboard
Creates an empty dashboard in Power BI. Tiles can be pinned to it from reports in the Power BI Service.
Additional Scopes:
...s.windows.net/powerbi/api/Content.Create
Create Dataset
Creates a new push dataset in Power BI. Push datasets support real-time data streaming via AddRows.
Additional Scopes:
...ws.net/powerbi/api/Dataset.ReadWrite.All
Delete Dataset
Deletes the specified dataset from Power BI.
Additional Scopes:
...ws.net/powerbi/api/Dataset.ReadWrite.All
Execute Queries
Executes DAX queries against the specified dataset and returns the results.
Additional Scopes:
...windows.net/powerbi/api/Dataset.Read.All
Export Report
Exports the specified report to a file (PDF, PPTX, PNG, etc.) from My Workspace or a specified group/workspace.
Additional Scopes:
....windows.net/powerbi/api/Report.Read.All
Get Dashboard
Returns the specified dashboard from My Workspace or a specified group/workspace.
Additional Scopes:
...ndows.net/powerbi/api/Dashboard.Read.All
Get Dataset
Returns the specified dataset from My Workspace or a specified group/workspace.
Additional Scopes:
...windows.net/powerbi/api/Dataset.Read.All
Add Rows
Adds new data rows to the specified table in a push dataset. Used for streaming/real-time data scenarios.
Additional Scopes:
...ws.net/powerbi/api/Dataset.ReadWrite.All
Get Refresh History
Returns the refresh history for the specified dataset.
Additional Scopes:
...windows.net/powerbi/api/Dataset.Read.All
Get Report
Returns the specified report from My Workspace or a specified group/workspace.
Additional Scopes:
....windows.net/powerbi/api/Report.Read.All
Get Report Pages
Returns a list of pages within the specified report from My Workspace or a specified group/workspace.
Additional Scopes:
....windows.net/powerbi/api/Report.Read.All
List Dashboards
Returns a list of dashboards from My Workspace or a specified group/workspace. Supports outputting one item at a time, all at once, first item only, or as a CSV file.
Additional Scopes:
...ndows.net/powerbi/api/Dashboard.Read.All
List Datasets
Returns a list of datasets from My Workspace (or from a specified group/workspace). Supports outputting one item at a time, all at once, first item only, or as a CSV file.
Additional Scopes:
...windows.net/powerbi/api/Dataset.Read.All
List Reports
Returns a list of reports from My Workspace or a specified group/workspace. Supports outputting one item at a time, all at once, first item only, or as a CSV file.
Additional Scopes:
....windows.net/powerbi/api/Report.Read.All
List Tables
Returns a list of tables within the specified push dataset. Supports outputting one item at a time, all at once, first item only, or as a CSV file.
Additional Scopes:
...windows.net/powerbi/api/Dataset.Read.All
Refresh Dataset
Triggers a refresh for the specified dataset. Only available for datasets in import/DirectQuery mode.
Additional Scopes:
...ws.net/powerbi/api/Dataset.ReadWrite.All
Get Tiles
Returns a list of tiles within the specified dashboard from My Workspace or a specified group/workspace.
Additional Scopes:
...ndows.net/powerbi/api/Dashboard.Read.All