Forum Discussion
Having Copilot agent talk to on-prem SQL and answer questions
Hello. I am trying to see if it is possible to create a Copilot agent that can take a natural language question and pass it to on-prem SQL server as a query and then respond with an answer. For examp...
1. Use Hybrid Connectivity: Connect to your local SQL database through Azure Hybrid Connectivity Services.
2. Use Local Data Gateway: Connect to your local SQL database through Power BI Data Gateway.
3. Use API Middle Tier: Develop a custom API to connect to the local SQL database.
4. Using Power Automate: Connect to a local SQL database through Power Automate.
5. Use SQL Server's REST API: Access the database directly through SQL Server's REST API.
6. Contact Microsoft Support: If none of the above methods work, it is recommended to contact Microsoft support team and provide detailed error messages and screenshots for further assistance.