pbix-to-mcp

# PBIX to MCP Converter Convert Power BI (.pbix) files into Model Context Protocol (MCP) servers using Google's genai-toolbox. ## Background The pain point of any SQL generation solutions based on text2sql, either they are agentic or RAG, remain the same: they are depends on LLM which is non-deterministic! While they create greate applications, it raise the question whether the dynamically generated queries (effectively code) are acurate therefore the results from these query can be trusted or not. Having been working on data domain for ages, my idea is to make best use of existing powerbi reports (tested code!) rather than dynamic generate query (image using a system with code generated on the fly!). This tool do three things: - Extract necessary information from powerbi reports (Thanks to `pbixray`) - Convert to a yaml file according to Google's `genai-toolbox` - Run `genai-toolbox` to get a MCP server, which you can connect to with any MCP-supported assistant client `genai-toolbox` allows you to pregenerated sql queries and expose them as MCP tool. So instead have LLM do everything: generate correct query, correct parameter, it now only need to make sure call the right tool, whose result can be easily spotted and evaluated. ## Features - **Complete Data Extraction**: Extract data models, tables, relationships, and schema information - **DAX Analysis**: Parse DAX measures, calculated columns, and calculated tables with complexity analysis - **UI Structure**: Extract report pages, visualizations, bookmarks, and layout information - **SQLite Database**: Generate SQLite databases from embedded Power BI data - **MCP Configuration**: Create genai-toolbox compatible YAML configurations - **Modular Architecture**: Clean, extensible codebase for custom integrations ## Quick Start Here's an example of what this tool can extract from a Power BI report:  *Original Power BI dashboard with com…