Microsoft Power BI Integration

Field	Description	Required	Format
Client ID	Microsoft Entra ID App Registration Client ID	Yes	`-`
Client Secret	Microsoft Entra ID App Registration Client Secret	Yes	`-`

add_rows_to_push_dataset — Append rows to a table in a Power BI Push Dataset

Parameters

string

required

ID of the Push Dataset (use list_datasets to find IDs)

string

required

Exact case-sensitive name of the table within the dataset

string

required

JSON array of row objects matching the table column schema

string

ID of the workspace (omit for My workspace)

Response

{
  "additionalProperties": false,
  "properties": {
    "success": {
      "title": "Success",
      "type": "boolean"
    },
    "error": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "title": "Error"
    },
    "rows_added": {
      "anyOf": [
        {
          "type": "integer"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "title": "Rows Added"
    }
  },
  "required": [
    "success"
  ],
  "title": "AddRowsToPushDatasetOutput",
  "type": "object"
}

execute_dax_query — Execute a DAX query against a Power BI dataset

Parameters

string

required

ID of the dataset to query (use list_datasets to find IDs)

string

required

DAX expression starting with EVALUATE

string

ID of the workspace (omit for My workspace)

boolean

Whether to include null values in the response (Default: true)

string

UPN of an effective identity for Row-Level Security

Response

{
  "additionalProperties": false,
  "properties": {
    "success": {
      "title": "Success",
      "type": "boolean"
    },
    "error": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "title": "Error"
    },
    "results": {
      "items": {
        "additionalProperties": true,
        "type": "object"
      },
      "title": "Results",
      "type": "array"
    }
  },
  "required": [
    "success"
  ],
  "title": "ExecuteDaxQueryOutput",
  "type": "object"
}

export_report — Export a Power BI report to PDF, PPTX, PNG, or other file format (Premium only)

Parameters

string

required

ID of the report to export (use list_reports to find IDs)

string

Output format: PDF, PPTX, PNG, CSV, XLSX, DOCX, XML, MHTML (Default: PDF)

string

ID of the workspace (omit for My workspace)

integer

Seconds between export status polls (Default: 5)

integer

Maximum seconds to wait for export completion (Default: 300)

Response

{
  "additionalProperties": false,
  "properties": {
    "success": {
      "title": "Success",
      "type": "boolean"
    },
    "error": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "title": "Error"
    },
    "export_id": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "title": "Export Id"
    },
    "status": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "title": "Status"
    },
    "report_id": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "title": "Report Id"
    },
    "format": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "title": "Format"
    },
    "resource_file_extension": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "title": "Resource File Extension"
    },
    "resource_location": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "title": "Resource Location"
    },
    "file_size_bytes": {
      "anyOf": [
        {
          "type": "integer"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "title": "File Size Bytes"
    },
    "file_base64": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "title": "File Base64"
    },
    "percent_complete": {
      "anyOf": [
        {
          "type": "integer"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "title": "Percent Complete"
    }
  },
  "required": [
    "success"
  ],
  "title": "ExportReportOutput",
  "type": "object"
}

get_refresh_history — Get the refresh history for a Power BI dataset

Parameters

string

required

ID of the dataset (use list_datasets to find IDs)

string

ID of the workspace (omit for My workspace)

integer

Number of most recent refresh entries to return (max 200)

Response

{
  "additionalProperties": false,
  "properties": {
    "success": {
      "title": "Success",
      "type": "boolean"
    },
    "error": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "title": "Error"
    },
    "refreshes": {
      "items": {
        "additionalProperties": true,
        "type": "object"
      },
      "title": "Refreshes",
      "type": "array"
    }
  },
  "required": [
    "success"
  ],
  "title": "GetRefreshHistoryOutput",
  "type": "object"
}

get_reports_by_id — Retrieve metadata for a single Power BI report by ID

Parameters

string

required

Power BI report ID (GUID)

string

Workspace group ID (omit for My workspace)

Response

{
  "additionalProperties": false,
  "properties": {
    "success": {
      "title": "Success",
      "type": "boolean"
    },
    "error": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "title": "Error"
    },
    "id": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "title": "Id"
    },
    "name": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "title": "Name"
    },
    "web_url": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "title": "Web Url"
    },
    "embed_url": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "title": "Embed Url"
    },
    "dataset_id": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "title": "Dataset Id"
    },
    "report_type": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "title": "Report Type"
    }
  },
  "required": [
    "success"
  ],
  "title": "GetReportsByIdOutput",
  "type": "object"
}

list_dashboards — List Power BI dashboards in a workspace

Parameters

string

ID of the workspace (omit for My workspace)

Response

{
  "additionalProperties": false,
  "properties": {
    "success": {
      "title": "Success",
      "type": "boolean"
    },
    "error": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "title": "Error"
    },
    "dashboards": {
      "items": {
        "additionalProperties": true,
        "type": "object"
      },
      "title": "Dashboards",
      "type": "array"
    }
  },
  "required": [
    "success"
  ],
  "title": "ListDashboardsOutput",
  "type": "object"
}

list_datasets — List Power BI datasets (semantic models) in a workspace

Parameters

string

ID of the workspace (omit for My workspace)

Response

{
  "additionalProperties": false,
  "properties": {
    "success": {
      "title": "Success",
      "type": "boolean"
    },
    "error": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "title": "Error"
    },
    "datasets": {
      "items": {
        "additionalProperties": true,
        "type": "object"
      },
      "title": "Datasets",
      "type": "array"
    }
  },
  "required": [
    "success"
  ],
  "title": "ListDatasetsOutput",
  "type": "object"
}

list_reports — List Power BI reports in a workspace

Parameters

string

ID of the workspace (omit for My workspace)

Response

{
  "additionalProperties": false,
  "properties": {
    "success": {
      "title": "Success",
      "type": "boolean"
    },
    "error": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "title": "Error"
    },
    "reports": {
      "items": {
        "additionalProperties": true,
        "type": "object"
      },
      "title": "Reports",
      "type": "array"
    }
  },
  "required": [
    "success"
  ],
  "title": "ListReportsOutput",
  "type": "object"
}

list_workspaces — List Power BI workspaces accessible to the authenticated user

Response

{
  "additionalProperties": false,
  "properties": {
    "success": {
      "title": "Success",
      "type": "boolean"
    },
    "error": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "title": "Error"
    },
    "workspaces": {
      "items": {
        "additionalProperties": true,
        "type": "object"
      },
      "title": "Workspaces",
      "type": "array"
    }
  },
  "required": [
    "success"
  ],
  "title": "ListWorkspacesOutput",
  "type": "object"
}

refresh_dataset — Trigger a refresh of a Power BI dataset

Parameters

string

required

ID of the dataset to refresh (use list_datasets to find IDs)

string

ID of the workspace (omit for My workspace)

string

Email notification behavior: NoNotification, MailOnCompletion, MailOnFailure (Default: NoNotification)

Response

{
  "additionalProperties": false,
  "properties": {
    "success": {
      "title": "Success",
      "type": "boolean"
    },
    "error": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "title": "Error"
    },
    "status_code": {
      "anyOf": [
        {
          "type": "integer"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "title": "Status Code"
    },
    "request_id": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "title": "Request Id"
    },
    "dataset_id": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "title": "Dataset Id"
    },
    "location": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "title": "Location"
    }
  },
  "required": [
    "success"
  ],
  "title": "RefreshDatasetOutput",
  "type": "object"
}

Using

Providers

Building

Tools

Microsoft Power BI Integration for AI Agents & Workflows

Overview

Authentication

OAuth2 (Microsoft Entra ID)

Required Credentials

OAuth Configuration

Available Actions

Parameters

Response

Parameters

Response

Parameters

Response

Parameters

Response

Parameters

Response

Parameters

Response

Parameters

Response

Parameters

Response

Response

Parameters

Response

Limits & Quotas

Databricks

Google Tag Manager

Mixpanel

Links

​Overview

​Authentication

​OAuth2 (Microsoft Entra ID)

​Required Credentials

​OAuth Configuration

​Available Actions

​Parameters

​Response

​Parameters

​Response

​Parameters

​Response

​Parameters

​Response

​Parameters

​Response

​Parameters

​Response

​Parameters

​Response

​Parameters

​Response

​Response

​Parameters

​Response

​Limits & Quotas

​Related integrations

Databricks

Google Tag Manager

Mixpanel

​Links

Overview

Authentication

OAuth2 (Microsoft Entra ID)

Required Credentials

OAuth Configuration

Available Actions

Parameters

Response

Parameters

Response

Parameters

Response

Parameters

Response

Parameters

Response

Parameters

Response

Parameters

Response

Parameters

Response

Response

Parameters

Response

Limits & Quotas

Related integrations

Links