How to Embed a NL to SQL Chatbot using Fabric Data Agent / Copilot with On-Prem Data Gateway?

• Is it possible to call Fabric Copilot or Data Agent through an API or SDK from a custom web application (outside Fabric UI)?
    Yes, fabric data agent/copilot can be called from custom apps via SDKs or APIs.

• If yes, does Copilot only use metadata (schema/columns) to generate SQL, or does it ever transmit raw data to Microsoft’s models?
    Only metadata/schema is used; raw data stays on-premises.

• Can the results be returned through Fabric APIs securely (with Entra ID authentication)?
    Yes, results can be securely returned via Fabric APIs with Entra ID.

• Has anyone successfully implemented a similar embedded NL2SQL chatbot or Copilot integration with Fabric yet?
    Limited public examples exist, but embedding Data Agent in custom chat apps is supported.

• Are there any licensing or capacity considerations when scaling this for multiple clients?
    Yes, you need Copilot capacity (F2+), manage per-user licenses, and scale Fabric SKUs appropriately.

You can build a chat style NL2SQL UI securely over onprem data.