Forum Discussion
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.
Community SupportHI hanzo7,
Thank you KevinChant Vinodh247, for your insights.
You can embed an NL2SQL chat using Fabric Data Agent. It uses only metadata/schema, keeps raw data on-premises, executes queries securely with user credentials, and returns structured results via Fabric APIs with Entra ID. Multiple data sources are supported, requiring F2+/P1+ capacity.Below is the link for your reference:
Fabric data agent creation (preview) - Learn how to create a Fabric data agent | Microsoft Learn
Thank you.
Super UserJust to check on this reply, are you advising that a Fabric Data Agent can connect directly to a database through a Data Gateway?