{"id":38311,"date":"2024-05-31T14:24:35","date_gmt":"2024-05-31T08:54:35","guid":{"rendered":"https:\/\/www.inogic.com\/blog\/?p=38311"},"modified":"2025-05-05T14:51:12","modified_gmt":"2025-05-05T09:21:12","slug":"integrate-business-central-with-microsoft-dataverse-using-virtual-table","status":"publish","type":"post","link":"https:\/\/www.inogic.com\/blog\/2024\/05\/integrate-business-central-with-microsoft-dataverse-using-virtual-table\/","title":{"rendered":"Integrate Business Central with Microsoft Dataverse using Virtual Table"},"content":{"rendered":"<p><img decoding=\"async\" class=\"alignleft size-full wp-image-38312\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/05\/Integrate-Business-Central-with-Microsoft-Dataverse-using-Virtual-Table.png\" alt=\"Integrate Business Central with Microsoft Dataverse using Virtual Table\" width=\"2800\" height=\"1600\" srcset=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/05\/Integrate-Business-Central-with-Microsoft-Dataverse-using-Virtual-Table.png 2800w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/05\/Integrate-Business-Central-with-Microsoft-Dataverse-using-Virtual-Table-300x171.png 300w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/05\/Integrate-Business-Central-with-Microsoft-Dataverse-using-Virtual-Table-1024x585.png 1024w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/05\/Integrate-Business-Central-with-Microsoft-Dataverse-using-Virtual-Table-768x439.png 768w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/05\/Integrate-Business-Central-with-Microsoft-Dataverse-using-Virtual-Table-1536x878.png 1536w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/05\/Integrate-Business-Central-with-Microsoft-Dataverse-using-Virtual-Table-2048x1170.png 2048w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/05\/Integrate-Business-Central-with-Microsoft-Dataverse-using-Virtual-Table-660x377.png 660w\" sizes=\"(max-width: 2800px) 100vw, 2800px\" \/><\/p>\n<p style=\"text-align: justify;\">In modern business applications, integrating data from multiple sources is crucial for streamlined operations. Microsoft Dataverse provides a unified data platform, making it easier to connect Business Central with other Dynamics 365 applications. One powerful feature facilitating this integration is Business Central <strong>Virtual Tables<\/strong>. These tables act as bridges between Business Central and the Microsoft Power Platform, enabling seamless access and interaction with external data sources. Despite their name, &#8220;Virtual Tables&#8221; are not stored within Dataverse but serve as connection points for performing CRUD (Create, Read, Update, Delete) operations.<\/p>\n<p style=\"text-align: justify;\">Here\u2019s how to create and set up virtual tables in Business Central:<\/p>\n<h3 style=\"text-align: justify;\"><strong><u>Step 1: Prepare Your Business Central Environment<\/u><\/strong><\/h3>\n<h4 style=\"text-align: justify;\"><strong>1.1 Sign in to Your Business Central Environment<\/strong><\/h4>\n<h4 style=\"text-align: justify;\"><strong>1.2<\/strong> <strong>Enable Virtual Tables<\/strong><\/h4>\n<ul style=\"text-align: justify;\">\n<li>Search for &#8220;<strong>Microsoft Entra Applications<\/strong>&#8221; within your Business Central environment.<\/li>\n<li>Locate the application named &#8220;<strong>Dynamics 365 Business Central for Virtual Tables<\/strong>&#8220;.<\/li>\n<li>Set its state to &#8220;Enabled.&#8221;<\/li>\n<\/ul>\n<p><img decoding=\"async\" class=\"alignleft size-full wp-image-38314\" style=\"border: 1px solid #000000; padding: 1px; margin: 1px;\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/05\/Integrate-Business-Central-with-Microsoft-Dataverse-using-Virtual-Table-2.png\" alt=\"Integrate Business Central with Microsoft Dataverse using Virtual Table\" width=\"1431\" height=\"735\" srcset=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/05\/Integrate-Business-Central-with-Microsoft-Dataverse-using-Virtual-Table-2.png 1431w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/05\/Integrate-Business-Central-with-Microsoft-Dataverse-using-Virtual-Table-2-300x154.png 300w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/05\/Integrate-Business-Central-with-Microsoft-Dataverse-using-Virtual-Table-2-1024x526.png 1024w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/05\/Integrate-Business-Central-with-Microsoft-Dataverse-using-Virtual-Table-2-768x394.png 768w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/05\/Integrate-Business-Central-with-Microsoft-Dataverse-using-Virtual-Table-2-660x339.png 660w\" sizes=\"(max-width: 1431px) 100vw, 1431px\" \/><\/p>\n<h3 style=\"text-align: justify;\"><strong><u>Step 2: Configure Business Central in Microsoft Dataverse<\/u><\/strong><\/h3>\n<ul style=\"text-align: justify;\">\n<li>Sign in to Microsoft Dataverse as Business Central User and from https:\/\/make.powerapps.com\/ go to <strong>All Tables <\/strong>and search for <strong>Business Central Virtual Data Source Configuration<\/strong>.<\/li>\n<li>Find the data source named &#8220;<strong>Business Central<\/strong>&#8221; in the list and edit it.<\/li>\n<\/ul>\n<p><img decoding=\"async\" class=\"alignleft size-full wp-image-38315\" style=\"border: 1px solid #000000; padding: 1px; margin: 1px;\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/05\/Integrate-Business-Central-with-Microsoft-Dataverse-using-Virtual-Table-3.png\" alt=\"Integrate Business Central with Microsoft Dataverse using Virtual Table\" width=\"1382\" height=\"260\" srcset=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/05\/Integrate-Business-Central-with-Microsoft-Dataverse-using-Virtual-Table-3.png 1382w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/05\/Integrate-Business-Central-with-Microsoft-Dataverse-using-Virtual-Table-3-300x56.png 300w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/05\/Integrate-Business-Central-with-Microsoft-Dataverse-using-Virtual-Table-3-1024x193.png 1024w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/05\/Integrate-Business-Central-with-Microsoft-Dataverse-using-Virtual-Table-3-768x144.png 768w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/05\/Integrate-Business-Central-with-Microsoft-Dataverse-using-Virtual-Table-3-660x124.png 660w\" sizes=\"(max-width: 1382px) 100vw, 1382px\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>Set the Environment name to your <strong>Business Central<\/strong> Environment name (Business Central tenants will have a default environment called &#8216;production&#8217;, which you can create with your custom name) and Save changes before setting Default Company.<\/li>\n<\/ul>\n<p><img decoding=\"async\" class=\"alignleft size-full wp-image-38316\" style=\"border: 1px solid #000000; padding: 1px; margin: 1px;\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/05\/Integrate-Business-Central-with-Microsoft-Dataverse-using-Virtual-Table-4.png\" alt=\"Integrate Business Central with Microsoft Dataverse using Virtual Table\" width=\"1377\" height=\"431\" srcset=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/05\/Integrate-Business-Central-with-Microsoft-Dataverse-using-Virtual-Table-4.png 1377w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/05\/Integrate-Business-Central-with-Microsoft-Dataverse-using-Virtual-Table-4-300x94.png 300w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/05\/Integrate-Business-Central-with-Microsoft-Dataverse-using-Virtual-Table-4-1024x321.png 1024w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/05\/Integrate-Business-Central-with-Microsoft-Dataverse-using-Virtual-Table-4-768x240.png 768w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/05\/Integrate-Business-Central-with-Microsoft-Dataverse-using-Virtual-Table-4-660x207.png 660w\" sizes=\"(max-width: 1377px) 100vw, 1377px\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>Set the Default Company value and Save the changes. This ensures that the virtual tables will use the correct company context when accessing Business Central data.<\/li>\n<\/ul>\n<p style=\"text-align: justify;\"><strong>Step 3<\/strong>: In Microsoft Dataverse from https:\/\/make.powerapps.com\/, go to <strong>All Tables <\/strong>and search for <strong>Available Business Central Table &#8211;&gt; Data <\/strong>and set &#8220;<strong>Visibility<\/strong>&#8221; to <strong>Yes<\/strong> to create a virtual table.<br \/>\n<img decoding=\"async\" class=\"alignleft size-full wp-image-38317\" style=\"border: 1px solid #000000; padding: 1px; margin: 1px;\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/05\/Integrate-Business-Central-with-Microsoft-Dataverse-using-Virtual-Table-5.png\" alt=\"Integrate Business Central with Microsoft Dataverse using Virtual Table\" width=\"1428\" height=\"700\" srcset=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/05\/Integrate-Business-Central-with-Microsoft-Dataverse-using-Virtual-Table-5.png 1428w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/05\/Integrate-Business-Central-with-Microsoft-Dataverse-using-Virtual-Table-5-300x147.png 300w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/05\/Integrate-Business-Central-with-Microsoft-Dataverse-using-Virtual-Table-5-1024x502.png 1024w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/05\/Integrate-Business-Central-with-Microsoft-Dataverse-using-Virtual-Table-5-768x376.png 768w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/05\/Integrate-Business-Central-with-Microsoft-Dataverse-using-Virtual-Table-5-660x324.png 660w\" sizes=\"(max-width: 1428px) 100vw, 1428px\" \/><\/p>\n<p style=\"text-align: justify;\">You can set <strong>Refresh<\/strong> to &#8220;<strong>Yes<\/strong>&#8221; to sync the latest table definition from <strong>Business Central<\/strong> to Microsoft <strong>Dataverse<\/strong> and update the virtual table.<\/p>\n<p style=\"text-align: justify;\"><img decoding=\"async\" class=\"alignleft size-full wp-image-38313\" style=\"border: 1px solid #000000; padding: 1px; margin: 1px;\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/05\/Integrate-Business-Central-with-Microsoft-Dataverse-using-Virtual-Table-1.png\" alt=\"Integrate Business Central with Microsoft Dataverse using Virtual Table\" width=\"1411\" height=\"545\" srcset=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/05\/Integrate-Business-Central-with-Microsoft-Dataverse-using-Virtual-Table-1.png 1411w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/05\/Integrate-Business-Central-with-Microsoft-Dataverse-using-Virtual-Table-1-300x116.png 300w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/05\/Integrate-Business-Central-with-Microsoft-Dataverse-using-Virtual-Table-1-1024x396.png 1024w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/05\/Integrate-Business-Central-with-Microsoft-Dataverse-using-Virtual-Table-1-768x297.png 768w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/05\/Integrate-Business-Central-with-Microsoft-Dataverse-using-Virtual-Table-1-660x255.png 660w\" sizes=\"(max-width: 1411px) 100vw, 1411px\" \/><br \/>\nYou can also add virtual elements to your solution and customize views, forms as you want.<\/p>\n<p style=\"text-align: justify;\">This integration ensures that data from Business Central is seamlessly accessible and manageable within Microsoft Dataverse.<\/p>\n<h2 style=\"text-align: justify;\"><strong>Conclusion<\/strong><\/h2>\n<p style=\"text-align: justify;\">Integrating Business Central data with Microsoft Dataverse via virtual tables is a game-changer for streamlining data management and enhancing business processes. By following simple steps, you can seamlessly connect and synchronize data across different applications within the Microsoft Power Platform.<\/p>\n<p><a href=\"https:\/\/www.inogic.com\/product\/productivity-apps\/map-my-relationships-dynamics-365-crm\/\" target=\"_blank\" rel=\"noopener\"><img decoding=\"async\" class=\"aligncenter wp-image-34428 size-full\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2022\/08\/Map-My-Relationship-1.gif\" alt=\"Map My Relationship\" width=\"800\" height=\"200\" \/><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>In modern business applications, integrating data from multiple sources is crucial for streamlined operations. Microsoft Dataverse provides a unified data platform, making it easier to connect Business Central with other Dynamics 365 applications. One powerful feature facilitating this integration is Business Central Virtual Tables. These tables act as bridges between Business Central and the Microsoft\u2026 <span class=\"read-more\"><a href=\"https:\/\/www.inogic.com\/blog\/2024\/05\/integrate-business-central-with-microsoft-dataverse-using-virtual-table\/\">Read More &raquo;<\/a><\/span><\/p>\n","protected":false},"author":11,"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,2887],"tags":[2888],"class_list":["post-38311","post","type-post","status-publish","format-standard","hentry","category-dataverse","category-dynamics-365-business-central","tag-integrate-business-central"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts\/38311","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\/11"}],"replies":[{"embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/comments?post=38311"}],"version-history":[{"count":0,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts\/38311\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/media?parent=38311"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/categories?post=38311"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/tags?post=38311"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}