Share via

Use SQL Server as knowledge base

misc981 66 Reputation points
2024-06-06T04:08:57.27+00:00

Currently working with a physical SQL server by using Power Automate flows to perform SQL queries.

Is it possible to just use the physical SQL server as a data source for AI Studio/Copilot, so users can interact with the data using generative AI as opposed to fixed/limited pre-defined SQL queries?

Can find many articles describing connecting to Azure SQL, but not a physical SQL server

Azure OpenAI Service
Azure OpenAI Service
An Azure service that provides access to OpenAI’s GPT-3 models with enterprise capabilities.
4,081 questions
SQL Server Other
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. LiHongMSFT-4306 31,566 Reputation points
    2024-06-06T05:58:43.8466667+00:00

    Hi @misc981 You might need to use Power Automate cloud flows or HTTP requests to retrieve data from your SQL server and format it. This would typically return a JSON object that you can then parse into a Table format to generate answers.

    See this doc: Use a custom data source for generative answers.

    Best regards,

    Cosmog Hong

    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.