FinOps hub agent in Microsoft Copilot Studio issue with Kusto Query MCP Server

[DMarshall-1]

Hi All

Looking for some advice, I have configured the Copilot Studio agent by following this guide

https://learn.microsoft.com/en-gb/cloud-computing/finops/toolkit/hubs/configure-ai-copilot-studio

however when I test the query it never works usually with an error similar to

I attempted to initialise the session (detect currency and discover scopes), but the Kusto queries returned syntax errors due to how the environment is structured through the connector.

The query failed because it was executed as a control command incorrectly, causing a syntax error. I will correct the execution and retry as a proper Kusto Query Language command.

It seems the connector is treating standard KQL as an admin command, causing the "dot prefix" error. This indicates that the environment is incorrectly routing query execution. Further progress requires troubleshooting connector configuration to allow query execution in "query" mode rather than "control" mode.

This action needs to be escalated to ensure the KQL queries can run properly.

I have deleted and recreated the agent a couple of times but it always fails to send the commands correctly.

putting the error into Copilot returns

ExecuteControlCommandAsync
/v1/rest/mgmt

The MCP server (or connector behind it) is calling the management endpoint, not the query endpoint.
And from Kusto’s design:

Management endpoint (/mgmt) ⇒ expects commands starting with .
Query endpoint (/query) ⇒ expects normal KQL

a cleaned up version of the error is

{ "ErrorCode": "SYN0100", "ErrorMessage": "Admin commands must have a dot (.) character as their first non-whitespace character", "Query": "Costs_v1_2() | where ChargePeriodStart >= ago(7d) | summarize count() by BillingCurrency | top 1 by count_", "Context": "Executing via management endpoint instead of query endpoint" }

I have tried both Microsoft Entra ID Integrated and Service Principal accounts with the same error in connection

Has anyone gotten it to work or know what is configured wrong so I can test this?

Thanks