Copilot for EventHouse Queryset

No direct API/SDK for Copilot in Eventhouse Queryset.

But you can automate it using the RTI MCP Server (preview) → lets AI agents turn natural language into KQL queries programmatically.

This way, you bypass manual Copilot UI and still get meaningful queries from your Eventhouse data.

Not currently possible. If this is important to you please consider voting for an existing idea or raising a new one at https://ideas.fabric.microsoft.com

Hi sandeep022,

Also, thanks to lbendlin  for the prompt and helpful response.

we would like to follow up to see if the solution provided by the super user resolved your issue. Please let us know if you need any further assistance.
If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

Regards,
Prasanna Kumar

Hi sandeep022,

We wanted to kindly check in to see if everything is working as expected after trying the suggested solution. If there’s anything else we can assist with, please don’t hesitate to ask.

If the issue is resolved, we’d appreciate it if you could mark the helpful reply as Accepted Solution — it helps others who might face a similar issue.

Warm regards,

Prasanna Kumar

Hi sandeep022,

Just a gentle reminder — has your issue been resolved? If so, we’d be grateful if you could mark the solution that worked as Accepted Solution, or feel free to share your own if you found a different fix.

This not only closes the loop on your query but also helps others in the community solve similar issues faster.

Thank you for your time and feedback!

Best,

Prasanna Kumar

Hi,

At the moment, Copilot for Eventhouse Queryset is a preview feature intended for interactive use within the Fabric experience. As far as the current public documentation indicates, there isn't a supported REST API, SDK, or programmatic endpoint that allows you to invoke Copilot to generate KQL queries.

If your goal is to automate query generation, you could consider these alternatives:

• Use the Fabric REST APIs or Kusto SDKs to execute KQL queries programmatically once they have been created.

• Use an Azure AI service or an LLM to generate KQL based on your schema, then validate and execute those queries against your KQL Database.

• Keep an eye on future Fabric announcements, as Copilot capabilities and APIs continue to evolve.

A couple of questions:

• Are you looking to generate KQL automatically for an internal application, or are you building an AI-powered analytics solution?

• Do you specifically need Copilot's reasoning, or would an API that generates KQL from natural language be sufficient?

If Microsoft plans to expose Copilot through an API in the future, it will most likely be announced in the Fabric roadmap or documentation.

If anyone from the product team can confirm whether API/SDK support for Copilot in Eventhouse Queryset is on the roadmap, that would be greatly appreciated.

If you found this reply helpful, please consider giving it a Kudos. If it answers your question, marking it as the Accepted Solution will help other community members with the same question.

Hi sandeep022 

As of now, Copilot for Eventhouse KQL Queryset does not have a public API endpoint or SDK* to automate query generation programmatically.

Current Status:

1. Copilot in Eventhouse Queryset is only available as an in-product preview inside Fabric Portal UI. You can use it to generate, explain, and optimize KQL queries.

2. Programmatic access: Microsoft hasn't exposed Copilot's NL-to-KQL generation via REST API/SDK yet. The Fabric APIs only allow you to run KQL queries against Eventhouse/KQL DB, not to call Copilot to generate them.

Workarounds you can try right now:

1. Fabric REST API + LLM : You can get the table schema using `GET /v1/workspaces/{workspaceId}/eventhouses/{eventhouseId}/databases/{databaseId}/tables` API. Then pass that schema + your business question to Azure OpenAI/GPT-4 and prompt it to generate KQL. Many teams are doing this as a "DIY Copilot".

2. Semantic Model: If your Eventhouse is connected to a semantic model, you can use Copilot in Power BI to generate DAX/Power Query, but not direct KQL.

3. Feature Request: Please upvote this on Fabric Ideas portal. Microsoft is actively adding API support for Copilot features, so this will likely come in future.

What Microsoft says: Copilot APIs for Fabric are on the roadmap. Keep an eye on "Fabric Copilot APIs" in the Microsoft Fabric release notes.

Let me know if you want a sample prompt to convert NL -> KQL using OpenAI + schema. Happy to share.

Thanks!