Skip to main content
Glama

pbi_scheduled_refresh_report

List scheduled refresh records for Power BI datasets in a workspace, showing failure history and current refresh status to track resolution.

Instructions

List scheduled refresh status for every dataset that had scheduled refreshes recently.

Scans all refreshable datasets in a workspace, identifies those with any Scheduled refresh in the past 7 days, and reports refresh records for the target date (local display timezone). If a qualified dataset has no refresh on the target date, its most recent Scheduled refresh is shown instead (e.g. when Power BI auto-disabled the schedule after repeated failures).

Each record includes a current_status snapshot of the dataset's most recent refresh (any type), so the reader can tell whether a past Scheduled failure has since been resolved by an on-demand or API-triggered refresh.

Note: Scheduled refreshes do NOT support the Enhanced Refresh Details API, so error info comes from serviceExceptionJson only.

Args: workspace_id: The workspace (group) ID. date: Optional date string (YYYY-MM-DD) in display timezone. Defaults to today. format: Output format - "json" (default) or "table" (Markdown table).

Returns: JSON report or Markdown table with flat refresh records and workspace-level summary.

Input Schema

TableJSON Schema
NameRequiredDescriptionDefault
workspace_idYes
dateNo
formatNojson

Output Schema

TableJSON Schema
NameRequiredDescriptionDefault
resultYes
Behavior5/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

With no annotations provided, the description carries the full burden of behavioral disclosure. It details scanning all refreshable datasets, checking the past 7 days, fallback behavior (shows most recent scheduled refresh if no refresh on target date), and the current_status snapshot. It also notes the error info source limitation. This is comprehensive and transparent.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness5/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is well-structured with paragraphs covering overview, fallback behavior, a note on API, and parameter details. It is front-loaded with the main purpose and each sentence adds value. No unnecessary repetition.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness5/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

Given the tool's complexity (scanning multiple datasets, handling fallbacks, providing status snapshots) and the presence of an output schema, the description covers all necessary aspects: what the tool does, its effect (read-only), the return content (records and summary), and a notable limitation. It is complete for an agent to understand and invoke correctly.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters4/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

The input schema has 0% description coverage, so the description must compensate. It does so by explaining the format parameter ('json' or 'table'), the date parameter (optional, 'YYYY-MM-DD' in display timezone, defaults to today), and the workspace_id is implicitly understood. It could provide more explicit guidance on workspace_id format, but overall adds meaningful context beyond the schema.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose5/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description clearly states the tool's purpose: 'List scheduled refresh status for every dataset that had scheduled refreshes recently.' It specifies the verb (list), resource (scheduled refresh status), and scope (datasets in a workspace). This distinguishes it from siblings like pbi_refresh_dataset (triggers a refresh) and pbi_refresh_manage (manages schedules).

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines4/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

The description implies use cases (viewing scheduled refresh status, checking failures resolved by on-demand refreshes) and mentions a limitation (no Enhanced Refresh Details API for scheduled refreshes). However, it does not explicitly state when not to use this tool or provide direct alternatives, leaving some guidance implicit.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

Install Server

Other Tools

Latest Blog Posts

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/FreelexHo/power-bi-mcp'

If you have feedback or need assistance with the MCP directory API, please join our Discord server