Skip to main content
Glama
619,919 tools. Updated 2026-09-28 19:52

"How to retrieve data from Power BI" matching MCP tools:

  • Create or replace DAX measures in Power BI Desktop or .pbip projects, with table and naming validation, optional data category, and before/after diff.
    Apache 2.0
  • Finalize a Power BI project as a ready-to-deliver .pbix or .pbit file: validates the project, exports via Power BI Desktop, and returns verified output path, SHA-256, and size.
    Apache 2.0
  • Copy formatting from a source visual to multiple target visuals of the same type in Power BI, preserving style while rejecting incompatible types.
    Apache 2.0
  • Identify Excel workbooks and Power BI Desktop models available as sources, and learn about other supported source forms for Power Query queries.
    MIT
  • Create a multi-level hierarchy from table columns, ordered from highest to lowest granularity for drill-down. Writes TMDL to a closed Power BI Desktop project.
    Apache 2.0

Matching MCP Servers

  • A
    license
    Not graded
    quality
    C
    maintenance
    Enables AI assistants to programmatically manage Power BI workspaces, reports, and dashboards while executing DAX queries and triggering dataset refreshes. It supports secure OAuth2 authentication for operations like report exporting, workspace management, and real-time push dataset updates.
    30 npm
    4
    MIT

Matching MCP Connectors

  • Connect to a Power BI semantic model and summarize its contents. Read-only, uses your permissions and row-level security. Run before show_measure.
    MIT
  • Persist Power BI model edits into .pbix, automatically choosing the right route (live Desktop or offline) and preserving data with atomic saves and backups.
    Cryptographic Autonomy 1.0 (Combined Work Exception)
  • Identifies Power BI Desktop models open on this machine for interactive use. Open the .pbix in Power BI Desktop first; not for unattended pipelines.
    Cryptographic Autonomy 1.0 (Combined Work Exception)
  • Clone an .rdl report to a new path, automatically regenerating report and data source IDs to prevent identity collisions in Power BI Report Builder.
    MIT
  • Add or edit a DAX measure in a closed Power BI .pbix file, scripting Power BI Desktop's save to persist the change back to disk.
    Cryptographic Autonomy 1.0 (Combined Work Exception)
  • Lists installed Power BI apps to retrieve workspace IDs for accessing datasets, tables, and running DAX queries through related tools.
    MIT
  • Run DAX queries against Power BI datasets to retrieve data rows. Supports row-level security impersonation and optional null inclusion.
    MIT
  • Ask a Microsoft Foundry agent any question in plain language and get its answer. Use for agent-specific tasks, but not for reading Power BI models.
    MIT
  • Delete a measure from a table in a .pbit template by editing its DataModelSchema JSON directly, without opening Power BI Desktop. Returns an error if the measure does not exist.
    Cryptographic Autonomy 1.0 (Combined Work Exception)
  • Connect to an open Power BI Desktop model to get a session ID for all model tools. Interactive only—unattended jobs should launch their own Desktop.
    Cryptographic Autonomy 1.0 (Combined Work Exception)
  • Create a Power BI report from a natural language description. Returns a session ID for subsequent tool calls.
    MIT
  • List every canonical Power BI visual type key from the formatting registry, tagged as data or container with card counts, for use with visual schema queries and adding visuals.
    Cryptographic Autonomy 1.0 (Combined Work Exception)
  • Define how selecting a data point in one visual filters or highlights another visual in your Power BI report.
    Cryptographic Autonomy 1.0 (Combined Work Exception)