![\"Dataverse](\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2026\/03\/Adding-Dataverse-as-a-Knowledge-Source-in-Microsoft-Copilot-Studio.png\")
<\/p>\n<\/p>\n
As AI agents become increasingly embedded in enterprise workflows, providing accurate, up-to-date, and structured knowledge becomes essential. Microsoft Copilot Studio allows developers to connect agents directly to Dataverse tables, enabling agents to answer employee questions using real, structured enterprise data.<\/p>\n
With Dataverse as a knowledge source, your agent can handle HR, salary, leave, and other operational queries reliably, reducing errors and ensuring consistent responses.<\/p>\n
Traditional knowledge sources (documents, PDFs, web content) are unstructured and can produce inconsistent AI responses. Dataverse tables provide structured, relational, and secure data, which makes agents:<\/p>\n
Example Use Case:<\/strong> Connecting Dataverse Entities to an HR Agent<\/p>\n In this solution, three Dataverse entities, Employees, SalaryDetails, and LeaveDetails store structured HR data.<\/p>\n By connecting these entities to an HR Agent, the agent can retrieve and relate information across multiple tables and display it to the end user.<\/p>\n This enables accurate, secure, and data-driven responses to employee queries related to salary, leave, and job information, ensuring consistency and reliability across HR operations.<\/p>\n Step 1: Create the Agent<\/strong><\/p>\n Once the data is ready, create a new agent in Copilot Studio :<\/p>\n Caption: Create a new Copilot agent to use the Dataverse tables as knowledge sources.<\/em><\/p>\n Step 2: Add Dataverse Tables as Knowledge Sources<\/strong><\/p>\n Caption: Add your Dataverse tables as knowledge sources so the agent can query structured data.<\/em><\/p>\n Step 3: Configure Instructions<\/strong><\/p>\n Provide the agent with clear instructions on how to answer employee queries:<\/p>\n Insert Image 5: Screenshot showing agent instruction editor<\/em><\/p>\n Caption: Define instructions to guide the agent in answering queries accurately and professionally.<\/em><\/p>\n Below Is The Instruction\u00a0 :-<\/strong><\/em><\/p>\n Instructions<\/p>\n Purpose The HR & Salary Agent helps employees with questions about: HR policies and processes Salary details (base pay, bonuses, pay frequency) Leave balances and history It provides accurate, data-driven, and confidential responses using the company\u2019s Dataverse tables:<\/p>\n General Guidelines Maintain a professional and friendly tone. Protect the confidentiality of all personal and salary-related data. Provide concise and accurate information based on the indexed tables. If information is missing or unclear, direct users to HR support. Skills \/ Capabilities The agent can: Retrieve employee information (job title, department, date of joining) Provide salary details (base salary, bonus, pay frequency) Summarize leave balances or leave history Answer questions about HR processes (leave requests, payroll guidance, benefits) Recognize when a query requires escalation to HR<\/p>\n Step-by-Step Instructions<\/strong><\/p>\n Example 1<\/strong> \u2013 Salary Query: User: \u201cWhat is Rahul Mehta\u2019s base salary?\u201d Agent: \u201cRahul Mehta\u2019s base salary is $65,000 with a monthly pay frequency. He also receives a $7,000 annual bonus.\u201d<\/p>\n Example 2<\/strong> \u2013 Leave Query: User: \u201cHow many casual leave days has Anita Sharma taken?\u201d Agent: \u201cAnita Sharma has taken 3 casual leave days from January 15 to January 17, 2026.\u201d<\/p>\n Example 3<\/strong> \u2013 HR Process Guidance: User: \u201cHow do I apply for leave?\u201d Agent: \u201cSubmit a leave request through the HR portal under \u2018Leave Management.\u2019 Select the leave type, dates, and submit. I can provide a direct link if needed.<\/p>\n Example 1<\/strong>: Salary Query User: \u201cWhat is Rahul Mehta\u2019s base salary?\u201d Agent: \u201cRahul Mehta\u2019s base salary is $65,000, with a monthly pay frequency. He also receives a $7,000 annual bonus.\u201d<\/p>\n Example 2<\/strong>: Leave Query User: \u201cHow many casual leave days has Anita Sharma taken?\u201d Agent: \u201cAnita Sharma has taken 3 casual leave days from January 15 to January 17, 2026.\u201d<\/p>\n Example 3<\/strong>: Process Guidance User: \u201cHow do I apply for leave?\u201d Agent: \u201cYou can submit a leave request through the HR portal under \u2018Leave Management.\u2019 Select the leave type, dates, and submit. If you need, I can guide you to the direct link.\u201d Follow-up and Closing Always ask: \u201cDo you need help with anything else?\u201d before ending the chat. Thank the user and encourage them to return for any HR, salary, or leave-related questions.<\/p>\n Step 4: Test the Agent<\/strong><\/p>\n Run sample queries to verify that the agent responds correctly:<\/p>\n Caption: Test the agent with real queries to ensure it returns accurate and consistent responses.<\/em><\/p>\n Adding Dataverse as a knowledge source transforms your Copilot agent into a reliable, data-driven assistant. With structured employee, salary, and leave data:<\/p>\n Can Copilot Studio connect directly to Dataverse tables?<\/strong><\/p>\n Yes. Copilot Studio allows agents to use Dataverse tables as knowledge sources, enabling them to retrieve structured enterprise data.<\/p>\n Why use Dataverse instead of documents as a knowledge source?<\/strong><\/p>\n Dataverse provides structured and relational data, which helps Copilot agents generate more accurate and consistent responses compared to unstructured documents.<\/p>\n Can Copilot agents access multiple Dataverse tables?<\/strong><\/p>\n Yes. Agents can connect to multiple related tables and retrieve linked information using keys such as EmployeeID.<\/p>\n","protected":false},"excerpt":{"rendered":" As AI agents become increasingly embedded in enterprise workflows, providing accurate, up-to-date, and structured knowledge becomes essential. Microsoft Copilot Studio allows developers to connect agents directly to Dataverse tables, enabling agents to answer employee questions using real, structured enterprise data. With Dataverse as a knowledge source, your agent can handle HR, salary, leave, and other\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":15,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[2354,3313,2361],"tags":[],"class_list":["post-44022","post","type-post","status-publish","format-standard","hentry","category-dataverse","category-microsoft-copilot-studio","category-technical"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts\/44022","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/users\/15"}],"replies":[{"embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/comments?post=44022"}],"version-history":[{"count":0,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts\/44022\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/media?parent=44022"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/categories?post=44022"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/tags?post=44022"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}\n
Step-by-Step: Add Dataverse Tables to Your Agent As a Knowledge<\/h3>\n
\n
![\"Dataverse](\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2026\/03\/Microsoft-Copilot-Studio-1.jpg\")
<\/p>\n\n
\n
![\"Dataverse](\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2026\/03\/Microsoft-Copilot-Studio-2.jpg\")
<\/p>\n\n
\n
\n
![\"Dataverse](\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2026\/03\/Microsoft-Copilot-Studio-3.jpg\")
<\/p>\n\n
![\"Dataverse](\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2026\/03\/Microsoft-Copilot-Studio-4.jpg\")
<\/p>\nConclusion<\/h3>\n
\n
FAQ <\/strong><\/h3>\n