Hi,
This sounds like one of three common issues: authentication, permissions, or the fact that the Power BI MCP connector is still in preview.
A few things to check:
Reconnect the connector
Remove the existing Power BI MCP connection.
Create a new connection.
Save and republish the agent before testing again.
Verify permissions
Ensure the account used by the connection has access to the Power BI workspace, semantic model, and underlying dataset.
Confirm the semantic model can be queried directly in Power BI.
Check if the connection is expiring
If it disconnects shortly after being created, it may be an authentication/token issue rather than a problem with your prompt.
Test with a simple query
Instead of a complex prompt, ask for something simple (for example, retrieve a small number of rows or a basic aggregation) to confirm the connector is working.
Review agent diagnostics
Check the agent run history and connection details for any authentication or authorization errors.
Since the Power BI MCP connector is currently in preview, intermittent connection issues and unexpected disconnects can occur. If everything is configured correctly and the connection continues to disconnect, it may be a platform issue rather than a configuration problem.
A couple of questions that may help narrow it down:
Does the connection disconnect after a certain period, or immediately after you run a query?
Is the semantic model in a Power BI workspace that you own, or is it shared with you?
