Integrations
Power BI
11 actions for Power BI.
Execute Power BI DAX Query#
Executes a DAX query on a Power BI dataset.
Plans: Trial, Pro, Premium, Enterprise · Type: PowerBIExecuteDAXQuery
Inputs#
| Field | Type | Required | Default | What it does |
|---|---|---|---|---|
| Workspace ID | Choice | Yes | (empty) | The ID of the Power BI workspace. |
| Dataset ID | Text | Yes | (empty) | The ID of the dataset to query. |
| DAX Query | Text | Yes | {input} | The DAX query string to execute. |
Use as an agent tool#
Tool name: powerbi_execute_dax_query
Execute a DAX query on a Power BI dataset
Get Power BI Dashboard Tiles#
Gets tiles in a Power BI dashboard.
Plans: Trial, Pro, Premium, Enterprise · Type: PowerBIGetDashboardTiles
Inputs#
| Field | Type | Required | Default | What it does |
|---|---|---|---|---|
| Workspace ID | Choice | Yes | (empty) | The ID of the Power BI workspace. |
| Dashboard ID | Text | Yes | {input} | The ID of the dashboard to get tiles from. |
Outputs#
| Output | Type |
|---|---|
| Tiles | List |
| Total Count | Number |
Use as an agent tool#
Tool name: powerbi_get_dashboard_tiles
Get all tiles in a Power BI dashboard
Get Power BI Dataset#
Gets details of a specific Power BI dataset.
Plans: Trial, Pro, Premium, Enterprise · Type: PowerBIGetDataset
Inputs#
| Field | Type | Required | Default | What it does |
|---|---|---|---|---|
| Workspace ID | Choice | Yes | (empty) | The ID of the Power BI workspace. |
| Dataset ID | Text | Yes | {input} | The ID of the dataset to retrieve. |
Outputs#
| Output | Type |
|---|---|
| Dataset | Object |
Use as an agent tool#
Tool name: powerbi_get_dataset
Get details of a specific Power BI dataset by its ID
Get Power BI Report#
Gets details of a specific Power BI report.
Plans: Trial, Pro, Premium, Enterprise · Type: PowerBIGetReport
Inputs#
| Field | Type | Required | Default | What it does |
|---|---|---|---|---|
| Workspace ID | Choice | Yes | (empty) | The ID of the Power BI workspace. |
| Report ID | Text | Yes | {input} | The ID of the report to retrieve. |
Outputs#
| Output | Type |
|---|---|
| Report | Object |
Use as an agent tool#
Tool name: powerbi_get_report
Get details of a specific Power BI report by its ID
Get Power BI Report Pages#
Gets pages in a Power BI report.
Plans: Trial, Pro, Premium, Enterprise · Type: PowerBIGetReportPages
Inputs#
| Field | Type | Required | Default | What it does |
|---|---|---|---|---|
| Workspace ID | Choice | Yes | (empty) | The ID of the Power BI workspace. |
| Report ID | Text | Yes | {input} | The ID of the report to get pages from. |
Outputs#
| Output | Type |
|---|---|
| Pages | List |
| Total Count | Number |
Use as an agent tool#
Tool name: powerbi_get_report_pages
Get all pages in a Power BI report
Get Power BI Workspace#
Gets details of a specific Power BI workspace.
Plans: Trial, Pro, Premium, Enterprise · Type: PowerBIGetWorkspace
Inputs#
| Field | Type | Required | Default | What it does |
|---|---|---|---|---|
| Workspace ID | Choice | Yes | (empty) | The ID of the Power BI workspace to retrieve. |
Outputs#
| Output | Type |
|---|---|
| Workspace | Object |
Use as an agent tool#
Tool name: powerbi_get_workspace
Get details of a specific Power BI workspace by its ID
List Power BI Dashboards#
Lists all dashboards in a Power BI workspace.
Plans: Trial, Pro, Premium, Enterprise · Type: PowerBIListDashboards
Inputs#
| Field | Type | Required | Default | What it does |
|---|---|---|---|---|
| Workspace ID | Choice | Yes | (empty) | The ID of the Power BI workspace. |
Outputs#
| Output | Type |
|---|---|
| Dashboards | List |
| Total Count | Number |
Use as an agent tool#
Tool name: powerbi_list_dashboards
List all dashboards in a Power BI workspace
List Power BI Datasets#
Lists all datasets in a Power BI workspace.
Plans: Trial, Pro, Premium, Enterprise · Type: PowerBIListDatasets
Inputs#
| Field | Type | Required | Default | What it does |
|---|---|---|---|---|
| Workspace ID | Choice | Yes | (empty) | The ID of the Power BI workspace. |
Outputs#
| Output | Type |
|---|---|
| Datasets | List |
| Total Count | Number |
Use as an agent tool#
Tool name: powerbi_list_datasets
List all datasets in a Power BI workspace
List Power BI Reports#
Lists all reports in a Power BI workspace.
Plans: Trial, Pro, Premium, Enterprise · Type: PowerBIListReports
Inputs#
| Field | Type | Required | Default | What it does |
|---|---|---|---|---|
| Workspace ID | Choice | Yes | (empty) | The ID of the Power BI workspace. |
Outputs#
| Output | Type |
|---|---|
| Reports | List |
| Total Count | Number |
Use as an agent tool#
Tool name: powerbi_list_reports
List all reports in a Power BI workspace
List Power BI Workspaces#
Lists all accessible Power BI workspaces.
Plans: Trial, Pro, Premium, Enterprise · Type: PowerBIListWorkspaces
Outputs#
| Output | Type |
|---|---|
| Workspaces | List |
| Total Count | Number |
Use as an agent tool#
Tool name: powerbi_list_workspaces
List all accessible Power BI workspaces
Refresh Power BI Dataset#
Triggers a dataset refresh in Power BI.
Plans: Trial, Pro, Premium, Enterprise · Type: PowerBIRefreshDataset
Inputs#
| Field | Type | Required | Default | What it does |
|---|---|---|---|---|
| Workspace ID | Choice | Yes | (empty) | The ID of the Power BI workspace. |
| Dataset ID | Text | Yes | {input} | The ID of the dataset to refresh. |
Outputs#
| Output | Type |
|---|---|
| Status | Text |
| Result | Object |
Use as an agent tool#
Tool name: powerbi_refresh_dataset
Trigger a dataset refresh in Power BI