Power BI: Integration für KI-Agenten
Query datasets, inspect schemas, and browse reports and workspaces
Verbinde Power BI mit Langdock und nutze es im Chat, in Agenten und in Workflows.
25 Actions · 2 Triggers
Beschreibungen, Actions und Beispiel-Prompts kommen direkt aus dem Produkt und sind dort auf Englisch verfasst.
Actions für Power BI
Jede Action ist ein Schritt, den ein Agent oder Workflow in Power BI ausführen kann.
- Execute query
Run DAX queries, DMVs, MDX queries, or INFO DAX functions against a Power BI dataset. Results with more than 50 rows are returned as a CSV file to preserve full data for analysis. DAX queries use the Execute Queries API; DMVs, MDX queries, and INFO DAX functions use the XMLA endpoint. On Pro and My Workspace, which have no XMLA, INFO.VIEW functions (e.g. INFO.VIEW.MEASURES()) run through the Execute Queries API instead, without measure expressions. If the account has Read but not Build permission on the model, DAX and INFO.VIEW queries run through Microsoft Fabric IQ instead (executedVia says which path ran), which needs the model setting that allows Read-only AI use and does not answer DMV or MDX. Semantic models with a live connection to Azure Analysis Services or SQL Server Analysis Services are not supported. Use the model's real table, column, and measure names: unless they already appeared in the conversation, call Get dataset schema (and Get semantic model measures when the query uses measures) before writing the query. INFO.TABLES(), INFO.COLUMNS(), and other INFO functions need admin rights on the model; for other users, use INFO.VIEW.TABLES(), INFO.VIEW.COLUMNS(), INFO.VIEW.MEASURES(), or INFO.VIEW.RELATIONSHIPS().
- Export paginated report (initiate)
Starts a Power BI paginated report export job and returns the export ID. Supports more formats than regular reports including XLSX, CSV, DOCX, XML. The export usually takes 20 to 60 seconds or longer: tell the user it is running and call the export fetch action once, about 30 seconds later, with the returned export ID. Do not poll in a loop.
- Export report to file (fetch)
Checks a Power BI report export (regular or paginated) by exportId and returns the file once the export has finished. Waits at most about 10 seconds, never for the whole export (typical export time: 15 to 45 seconds): while it is still running it returns status running (or notStarted) with percentComplete and retryAfterSeconds, and the model should tell the user and check again after that interval, not immediately.
- Export report to file (initiate)
Starts a Power BI report export job (PDF, PPTX or PNG) and returns the export ID. The export takes about 15 to 45 seconds for a one-page report: tell the user it is running and call the fetch action once, about 20 seconds later, with the returned export ID. Do not poll in a loop.
- Get dashboard details
Gets detailed information about a specific Power BI dashboard.
- Get dataset dependencies
Gets reports and dashboards that use a specific Power BI dataset.
- Get dataset details
Gets detailed information about a specific Power BI dataset.
- Get dataset schema
Gets tables and columns from a Power BI semantic model. Call this first for schema or table structure questions; it does not return measure DAX expressions or relationships. When the model author prepared the model for AI, it also returns aiContext (the author's AI instructions, measure descriptions and verified-answer phrases) and column and table descriptions: follow the instructions and prefer the described measures when you write DAX. Columns marked hiddenFromAi are hidden by the author, so do not use them unless the user names them. When the user wants the full semantic model, a dataset description including measures and joins, or DAX grounding, also call Get semantic model measures and Get semantic model relationships. Also works on Pro and My Workspace, which have no XMLA; there, dataType holds Power BI type names (executedVia says which path ran). Semantic models with a live connection to Azure Analysis Services or SQL Server Analysis Services are not supported.
- Get report details
Gets detailed information about a specific Power BI report, including the datasetId and datasetWorkspaceId to pass as the dataset and groupId of semantic model actions.
- Get semantic model measures
Gets measures (name, table, and DAX expression when permitted) from a Power BI semantic model. Call this whenever the user asks for measures, DAX measures, or KPIs; Get dataset schema does not include them. When the user wants the full semantic model, a dataset description including measures and joins, or DAX grounding, also call Get dataset schema and Get semantic model relationships. Also works on Pro and My Workspace, which have no XMLA; there it returns names, tables, and descriptions but no DAX expressions (executedVia says which path ran). Semantic models with a live connection to Azure Analysis Services or SQL Server Analysis Services are not supported.
- Get semantic model relationships
Gets relationships (from and to table and column) from a Power BI semantic model. Call this whenever the user asks how tables join or relate; Get dataset schema does not include relationships. When the user wants the full semantic model, a dataset description including measures and joins, or DAX grounding, also call Get dataset schema and Get semantic model measures. Also works on Pro and My Workspace, which have no XMLA (executedVia says which path ran). Semantic models with a live connection to Azure Analysis Services or SQL Server Analysis Services are not supported.
- Get table count
Gets the row count of a specific table in a Power BI dataset.
- Get table sample
Gets a sample of data from a specific table in a Power BI dataset. Returns up to 10 rows (default 5). For more rows, use Execute query.
- Get tile details
Gets detailed information about a specific Power BI dashboard tile.
- List dashboard tiles
List tiles on a dashboard.
- List dashboards
Lists dashboards in a workspace.
- List dataset tables (Push API only)
Lists tables for a push dataset to discover exact table and column names. Only works for Push API datasets. For Import, DirectQuery, or Composite datasets, use 'Get dataset schema' instead.
- List datasets
Lists the datasets of one workspace: My Workspace (the user's personal workspace) unless groupId is set. It does not cover other workspaces. To find semantic models across all workspaces the user can access, use 'Search reports and semantic models across workspaces' (search_across_workspaces), if it is available.
- List report pages
List pages for a report.
- List reports
Lists the reports of one workspace: My Workspace (the user's personal workspace) unless groupId is set. It does not cover other workspaces, so it cannot answer how many reports exist across workspaces: for that, call 'List workspaces' and then this action once per workspace. To find a report by name across all workspaces the user can access, use 'Search reports and semantic models across workspaces' (search_across_workspaces), if it is available.
- List workspaces
List workspaces (groups) the user has access to.
- Search datasets
Searches for Power BI datasets by name in one workspace only: My Workspace (the user's personal workspace) unless groupId is set. It does not look in other workspaces, so an empty result does not mean the semantic model does not exist. When the workspace is unknown, or to search all workspaces the user can access, use 'Search reports and semantic models across workspaces' (search_across_workspaces) instead, if it is available.
- Search reports
Searches for Power BI reports by name or description in one workspace only: My Workspace (the user's personal workspace) unless groupId is set. It does not look in other workspaces, so an empty result does not mean the report does not exist. When the workspace is unknown, or to search all workspaces the user can access, use 'Search reports and semantic models across workspaces' (search_across_workspaces) instead, if it is available.
- Search reports and semantic models across workspaces
Searches Power BI reports and semantic models (datasets) by name, description, or workspace name across every workspace the user can access, including My Workspace. Use this when the workspace is unknown. Each result includes its workspace ID and name and a webUrl to open it in Power BI, so no detail call is needed just for a link; pass a semantic model's ID as the dataset ID and its workspace ID as the workspace to other Power BI actions. For My Workspace items the workspace ID is null: leave the workspace empty in follow-up actions. Newly created or renamed items can take a while to appear.
- Search workspaces
Searches for Power BI workspaces by name. Returns matching workspaces with ID, name, type, and capacity details.
Trigger für Power BI
Ein Trigger startet einen Workflow, sobald in Power BI etwas passiert.
- Data value changed
Triggers when the result of a DAX, DMV, or MDX query changes.
- Dataset refresh completed
Triggers when a Power BI dataset refresh completes or fails.
Einrichtung und Berechtigungen
Eine Action kann nach deiner Bestätigung fragen, bevor sie ausgeführt wird. In einem Agenten steht jede Action auf „Immer erlauben“ oder „Braucht Bestätigung“.