Forum Discussion
MCP server for Power BI Service
I see that there is an MCP server available in https://github.com/jonaolden/pbixray-mcp-server for getting the list of tables, measure definitions, etc. from a local .pbix file
Do we have any similar MCP server for connecting to the Power BI semantic model in Power BI Service / Fabric workspace and get the list of tables, measure definitions, etc?
If such an MCP server is not available, do we have any REST API or Python SDK (similar to https://github.com/Hugoberry/pbixray ) to get the list of tables, measure definitions, etc. from a remote semantic model in Fabric workspace?
CC: Anonymous ibarrau
Thanks,
Saravanan P
Hi. Microsoft is working on an MCP for semantic models. You can find it here: https://github.com/microsoft/fabric-toolbox/tree/main/tools/SemanticModelMCPServer
The most advanced development I have seen regarding this is in this article: https://www.sqlbi.com/articles/introducing-ai-and-agentic-development-for-business-intelligence/
I hope that helps,
2 Replies
Hi. Microsoft is working on an MCP for semantic models. You can find it here: https://github.com/microsoft/fabric-toolbox/tree/main/tools/SemanticModelMCPServer
The most advanced development I have seen regarding this is in this article: https://www.sqlbi.com/articles/introducing-ai-and-agentic-development-for-business-intelligence/
I hope that helps,
There is a very good series from Kurt Buhler (Data Goblin) for this: Learn MCP servers for data and analytics! (000 - About the series)
