Forum Discussion

TienTran123's avatar
TienTran123
Copper Contributor
Dec 18, 2024

My copilot studio doesn't read data from database connector.

I have a azure database source connected successfully to my copilot studio though a connector.

When i tested the knowledge in some topics, no matter what i texted (give me some examples, find me a random data), it always give me the same result 'No information was found that could help answer this.'

I have tried to add synonyms and descriptions to the data source but none of them worked, can anyone help me? also the table have about 900k rows

4 Replies

  • Hey Guy... I have tried this with DataVerse and Sharepoint . worked well . i am sharing this it may help you

    https://youtu.be/0HdhYQ2P9-I

  • BhargavG's avatar
    BhargavG
    Copper Contributor

    Tien, I am facing a similar issue, and I believe use of synonyms and glossaries is very import for data discovery. Have you set those up for the columns in your table?
    In my case I tried querying the data from SQL through my agent, however it does not have access to specific data records. I believe you could be facing of these issues.

    • TienTran123's avatar
      TienTran123
      Copper Contributor

      Yeah already tried that and it had the same result. Guess i just wait for future update.

Resources