Connect to Microsoft Power BI to manage dashboards, datasets, reports, dataflows, and workspaces. Access business intelligence data, execute queries, refresh datasets, and export reports programmatically. Authenticate using a Bearer token obtained from Azure AD with appropriate Power BI API permissions.
Use Power BI as a trigger to kick off a workflow, or use it as an action to do something automatically in your workflow.
No triggers available
Initiate an admin scan to retrieve detailed metadata from Power BI workspaces. Returns a scan ID to track the async operation. Requires admin (Tenant.Read.All) permissions.
Retrieve the results of a workspace scan operation. Use the scan ID from GetWorkspaceInfo action. Requires admin (Tenant.Read.All) permissions.
Get a list of dashboards from a Power BI workspace. Returns dashboard names, IDs, and metadata.
Get detailed information about a specific Power BI dashboard including metadata, URLs, and access permissions.
Get all tiles from a Power BI dashboard. Tiles are visual elements like charts, tables, and KPIs displayed on the dashboard.
Get a list of dataflows from a Power BI workspace. Dataflows are used for data preparation and ETL processes.
Get detailed information about a specific Power BI dataflow including configuration, metadata, and access permissions.
Get all data sources used by a Power BI dataflow. Data sources include databases, files, and web services used for data extraction.
Get the transaction history for a Power BI dataflow. Shows refresh operations, status, start/end times, and error details.
Trigger a refresh operation for a Power BI dataflow. Extracts data from sources and applies transformations.
Get a list of datasets from a Power BI workspace. Datasets contain data models used in reports and dashboards.
Get detailed information about a specific Power BI dataset including metadata, configuration, and capabilities.
Get all tables from a Power BI dataset. Returns table names, columns, measures, and schema information.
Add rows of data to a Power BI dataset table. Only works with Push Datasets that have the AddRows API enabled.
Execute DAX queries against a Power BI dataset. Returns query results in tabular format.
Trigger a refresh operation for a Power BI dataset. Updates the dataset with latest data from sources.
Get the refresh history for a Power BI dataset. Shows refresh operations, status, start/end times, and error details.
Get all gateways accessible to the authenticated user. Gateways enable secure data transfer between on-premises data sources and Power BI cloud service.
Get detailed information about a specific gateway including configuration, status, version, and contact information.
Get all data sources configured on a specific gateway. Data sources represent connections to databases, files, and other data systems accessible through the gateway.
Get detailed information about a specific data source on a gateway including connection details, credentials, and user permissions.
Get the connection status of a specific data source on a gateway. Indicates whether the datasource is reachable and ready for use.
Get the list of users who have access to a specific data source. Shows user permissions and access levels for the datasource.
Get all workspaces (groups) accessible to the authenticated user. Workspaces are containers for Power BI content like dashboards, reports, and datasets.
Get detailed information about a specific workspace (group) including metadata, users, capacity information, and settings.
Get all dashboards within a specific workspace (group). Returns dashboard metadata including IDs, names, and embed URLs.
Get all datasets within a specific workspace (group). Returns dataset metadata including refresh capabilities, gateway requirements, and data source information.
Get all reports within a specific workspace (group). Returns report metadata including IDs, names, embed URLs, and associated datasets.
Get all reports in a workspace. Reports are interactive visualizations built from Power BI datasets. Supports pagination.
Get detailed information about a specific report including metadata, dataset associations, and embed URLs.
Get all pages from a specific report. Pages are individual tabs/views within a Power BI report.
Export a Power BI report to PDF, PPTX, or PNG format. This operation may take several minutes for large reports.
