About Microsoft Power BI

Power BI is Microsoft's business analytics service for creating and sharing interactive data visualizations and reports. It connects to hundreds of data sources, offers a drag-and-drop report builder, and embeds into Microsoft Teams, SharePoint, and third-party apps. It is part of the broader Microsoft Fabric platform. In April 2025 Microsoft raised per-user pricing 40% (Pro from $10 to $14, PPU from $20 to $24); those prices remain in effect in 2026. P-SKU Premium capacity was discontinued for new customers in 2024, replaced by Fabric F-SKUs.

AI Agent Use Cases

- Connects to 100+ data sources including Excel, SQL, Azure, Salesforce, and REST APIs

- Drag-and-drop report and dashboard builder with 30+ visualization types

- DAX formula language for custom calculations and measures

- AI-powered Q&A natural language queries and automated insights

- Embedded analytics SDK for third-party applications

- Microsoft Fabric integration for unified data engineering, warehousing, and BI

Available Actions

These are the specific actions that AI agents can perform with this tool

Get Dashboard Information

1 input

Retrieve specific dashboard information from Power BI's My workspace using its ID.

Inputs

dashboardId

The unique identifier for the dashboard you want to retrieve.

Get Groups

3 inputs

Fetch a list of workspaces the user has access to using the Power BI REST API.

Inputs

filter

Returns a subset of results based on an OData filter condition.

skip

Number of results to skip from the beginning.

top

Returns only the first n results.

Get Reports

Fetch a list of Power BI reports from My workspace.

Get Workspaces

4 inputs

Retrieve a list of all workspaces within the organization in Power BI, with options for filtering, expanding data types, and skipping results.

Inputs

$top

Returns only the first 'n' results.

$expand

Expands the specified data types inline in the response.

$filter

Returns a subset of results based on the specified filter condition.

$skip

Skips the first 'n' results. Must be used with $top to fetch results beyond the first 5000.

List Items in Workspace

1 input

List items in a specific Power BI workspace to view all resources available.

Inputs

groupId

The unique identifier (UUID) of the Power BI workspace/group to list items from.