Forum Discussion

ChetanK004's avatar
ChetanK004
Frequent Visitor
10 months ago
Solved

Power BI MCP Server not connecting to Power service

Hi team,

 

I have set-up the Power BI MCP server(https://github.com/microsoft/powerbi-modeling-mcp) in my local (In both ways Using the extension as well as the local install) I use GitHub copilot and GitHub copilot chat extensions to run the commands.

 

The issue am facing is when i try to connect to Power BI service, i get the following error:

 

The MCP server is failing to generate the MWC (Microsoft Web Credentials) token, even though Tabular Editor works. This suggests the MCP server may need to use cached credentials or authenticate differently.

This is an authentication/credential caching issue with the MCP server. The server needs access to your Power BI credentials but isn't able to retrieve them.


The error consistently shows it's failing at the "Generating MWC token" step, which is a Power BI authentication component that Tabular Editor handles differently than this MCP server.

 

Note: Although I am able to connect to local Power BI desktop ( But if the desktop uses live connection to fabric workspace i get the same above error)

 

These are the things that we have setup:

1) Connected to GitHub account in vs code for copilot (With Email:A****)

2) Connected to Microsoft account in vs code (With Email:B****)

3) Using Email:B**** to connect to apps,powerbi.com

3) Have Enabled Fabric trail for my user and made sure my workspace is using it. 

4) I am the Admin of workspace , and have all the permission on the dataset in side the workspace

5) Enabled MCP protocal at the tenant level

6) I am able to connect to the same workspace using XMLA endpoint via tabular editor

 

Am i missing any configiration for connecting to power bi workspace?

  • Hi Robbief,

    Thank you for the update.

    Based on my understanding, there is no configuration or workaround that enables the Power BI Modeling MCP Server to authenticate directly to Power BI Service or Fabric workspaces. The MCP server does not support the interactive WAM/MWC authentication flow required by the Service. This limitation persists regardless of permissions, tenant settings, or account alignment.

    If you need to work with service hosted semantic models or metadata, the available option is XMLA based tooling such as Tabular Editor, which is designed to authenticate to Power BI Service or Fabric. MCP is currently intended for local model scenarios and code generation.

    If this capability is important to your workflow, please raise a request in the Fabric Ideas forum at: https://ideas.fabric.microsoft.com.

    We hope this information helps resolve the issue. Should you have any further queries, please feel free to contact the Microsoft Fabric community.

    Thank you.

9 Replies