Create a complete Power BI dashboard from a local dataset path. USE THIS TOOL when the user says "create a dashboard/report from this dataset" and provides a local file path. Prefer this over create_report because this reads real data rows and does not require an Anthropic API key.

Supports CSV files. Returns a local .pbit file_path, not base64.

Create a new Power BI report from a natural language description. Do NOT use this when the user provides a CSV/dataset file path; use create_dashboard instead. This tool needs a valid Anthropic API key. Returns a session_id to use in all subsequent tool calls. Example: "monthly sales by region with YoY comparison for retail team"

Add a visual to an existing report session. description: plain English e.g. "bar chart of units sold by product category" page_name: which page to add to (default: Overview)

Extract color palette from a dashboard image and apply it as the report theme. image_base64: base64-encoded image string media_type: image/png or image/jpeg

Edit report styling via natural language. Examples:

• "make all charts use a dark navy background"

• "change primary color to #FF5733"

• "use a minimal flat style with no borders"

Add a slicer or filter to the report. Examples:

• "add a Year slicer to the Overview page"

• "add a Region dropdown filter"

• "add a date range filter for all pages" page_name: specific page, or None for all pages

Compile the current session into a .pbix file and return it as base64. The base64 string can be decoded and saved as report.pbix.

Compile the current session and save the .pbit locally. Claude Desktop should prefer this over export_pbix to avoid huge base64 output.

Compile the current session, save the .pbit on the hosted server, and return a public download URL. Set PUBLIC_BASE_URL on Railway for this tool.

Create a Power BI dashboard from a CSV file. Auto-generates KPI cards, bar chart, line chart, pie chart, and slicer — no prompt required. csv_base64: base64-encoded CSV bytes. filename: original filename (used for table naming in the data model). prompt: optional report title override (e.g. "Q4 Sales Overview"). image_base64: optional branding image (base64) to extract theme colors from. Returns: session_id, pbix_base64 (save as .pbit), report_title, columns_detected, domain.

Create a Power BI dashboard from raw CSV text. This is easier to use from Claude Desktop than base64 input. Does not require an Anthropic API key unless image theming is used elsewhere.

Create a Power BI dashboard from a CSV file already on this computer. Preferred for Claude Desktop because it avoids putting large CSV/base64 data into the conversation context.

Return the current report structure for inspection. Useful for understanding what has been generated before editing.