Fabric Data Agent with GitHub Copilot Agent Mode

NHariGouthami thanks for sharing this information. This workflow works based on my own testing of similar approach. While GitHub Copilot in VS Code with MSSQL extension creates a very useful AI-powered development environment, I also found it to be quite time consuming to create the data schema context for the Copilot before it's able to produce usable meaningful results. The amount of work grows quickly when there are many large tables to discover for the data agent or there are connected data sources like multiple lakehouses of warehouses. In such scenario the interaction with the Copilot, even though it's faster than doing similar work manually, becomes a bottleneck in the process. I have found in my scenario, that the botleneck can be removed by creating a simple MCP server that rund locally in VS Code and interacts with Fabric using both Fabric REST API and SQL endpoint. With MCP server and GitHub Copilot in Agentic mode it is possible to fully automate schema discovery with data sampling and context population including creating and configuring Fabric items along the process if necessary. I am in a process of creating a public GitHub repo with my MCP server code and can share if interested. Thanks again, for sharing a very useful topic.