{"id":40187,"date":"2025-01-10T14:43:42","date_gmt":"2025-01-10T09:13:42","guid":{"rendered":"https:\/\/www.inogic.com\/blog\/?p=40187"},"modified":"2025-01-10T14:43:42","modified_gmt":"2025-01-10T09:13:42","slug":"visualizing-data-models-with-copilot-in-an-erd-view-part-2","status":"publish","type":"post","link":"https:\/\/www.inogic.com\/blog\/2025\/01\/visualizing-data-models-with-copilot-in-an-erd-view-part-2\/","title":{"rendered":"Visualizing Data Models with Copilot in an ERD View &#8211; Part 2"},"content":{"rendered":"<p>Exploring the capabilities of <a href=\"https:\/\/www.inogic.com\/services\/ai-solutions\/microsoft-dynamics365-powerplatform-chatgpt-copilot-consulting-services\/?utm_source=inogic-t-blog&amp;utm_medium=copilot&amp;utm_campaign=itblog&amp;utm_id=copilot\" target=\"_blank\" rel=\"noopener\"><strong>Copilot <\/strong>within Microsoft Dynamics<\/a> and <a href=\"https:\/\/www.inogic.com\/services\/?utm_source=inogic-t-blog&amp;utm_medium=powerplatform&amp;utm_campaign=itblog&amp;utm_id=powerplatform\" target=\"_blank\" rel=\"noopener\">Power Platform<\/a> unlocks exciting possibilities for enhancing business application development. A key element of this innovation lies in constructing intricate data models that span multiple tables. The \u2018<em><strong>Create New Tables&#8217;<\/strong><\/em> feature in Power Apps, now enhanced to include existing tables, transforms the process by allowing users to seamlessly create and visualize data models through an intuitive <strong>Entity Relationship Diagram (ERD)<\/strong> view.<\/p>\n<p>In my previous blog, <em>\u201c<\/em><a href=\"https:\/\/www.inogic.com\/blog\/2024\/07\/visualizing-data-models-with-copilot-in-an-erd-view\/\" target=\"_blank\" rel=\"noopener\">Visualizing Data Models with Copilot in an ERD View<\/a>,<em>\u201d <\/em>I explained how the visualization of data models in an <strong>ERD<\/strong> view was previously limited to new tables. With this enhanced functionality, you can now incorporate existing tables into the <strong>ERD<\/strong> view, making data modeling more dynamic, versatile, and efficient.<\/p>\n<h3>Prerequisites:<\/h3>\n<ul>\n<li><strong>Power Apps<\/strong>: Access to Microsoft Dataverse with permissions to create apps and tables.<\/li>\n<li><strong>Copilot<\/strong>: Copilot must be activated within your environment and tenant.<\/li>\n<\/ul>\n<p>Here\u2019s how to set up the existing tables in <strong>ERD <\/strong>view:<\/p>\n<h4>Step 1: Log in to the Microsoft Dataverse Preview<\/h4>\n<ul>\n<li>Visit <a href=\"https:\/\/make.preview.powerapps.com\" target=\"_blank\" rel=\"noopener\">Microsoft Dataverse Preview<\/a> and sign in with your credentials.<\/li>\n<li><strong>Click Create new tables feature.<\/strong><\/li>\n<\/ul>\n<p><strong> <img decoding=\"async\" class=\"alignnone size-full wp-image-40188\" style=\"border: 1px solid #000000; padding: 1px; margin: 1px;\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2025\/01\/1Visualizing-Data-Models-with-Copilot.png\" alt=\"Visualizing Data Models with Copilot\" width=\"975\" height=\"245\" srcset=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2025\/01\/1Visualizing-Data-Models-with-Copilot.png 975w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2025\/01\/1Visualizing-Data-Models-with-Copilot-300x75.png 300w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2025\/01\/1Visualizing-Data-Models-with-Copilot-768x193.png 768w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2025\/01\/1Visualizing-Data-Models-with-Copilot-660x166.png 660w\" sizes=\"(max-width: 975px) 100vw, 975px\" \/><\/strong><\/p>\n<h4><strong>\u00a0<\/strong>Step 2: Add Existing Tables to the ERD View<\/h4>\n<ul>\n<li>A new <strong>Existing Table<\/strong> button is now available, allowing you to select existing Dataverse tables for inclusion in the <strong>ERD<\/strong> view.<\/li>\n<\/ul>\n<p><strong> <img decoding=\"async\" class=\"alignnone size-full wp-image-40189\" style=\"border: 1px solid #000000; padding: 1px; margin: 1px;\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2025\/01\/2Visualizing-Data-Models-with-Copilot.png\" alt=\"Visualizing Data Models with Copilot\" width=\"1439\" height=\"553\" srcset=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2025\/01\/2Visualizing-Data-Models-with-Copilot.png 1439w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2025\/01\/2Visualizing-Data-Models-with-Copilot-300x115.png 300w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2025\/01\/2Visualizing-Data-Models-with-Copilot-1024x394.png 1024w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2025\/01\/2Visualizing-Data-Models-with-Copilot-768x295.png 768w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2025\/01\/2Visualizing-Data-Models-with-Copilot-660x254.png 660w\" sizes=\"(max-width: 1439px) 100vw, 1439px\" \/><\/strong><\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-40190\" style=\"border: 1px solid #000000; padding: 1px; margin: 1px;\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2025\/01\/3Visualizing-Data-Models-with-Copilot.png\" alt=\"Visualizing Data Models with Copilot\" width=\"629\" height=\"761\" srcset=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2025\/01\/3Visualizing-Data-Models-with-Copilot.png 629w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2025\/01\/3Visualizing-Data-Models-with-Copilot-248x300.png 248w\" sizes=\"(max-width: 629px) 100vw, 629px\" \/><\/p>\n<h4>Step 3: Visualize Relationships<\/h4>\n<ul>\n<li>Once existing tables are added, the <strong>ERD<\/strong> view automatically displays relationships between them.<\/li>\n<\/ul>\n<p><strong><img decoding=\"async\" class=\"alignnone size-full wp-image-40191\" style=\"border: 1px solid #000000; padding: 1px; margin: 1px;\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2025\/01\/4Visualizing-Data-Models-with-Copilot.png\" alt=\"Visualizing Data Models with Copilot\" width=\"293\" height=\"495\" srcset=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2025\/01\/4Visualizing-Data-Models-with-Copilot.png 293w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2025\/01\/4Visualizing-Data-Models-with-Copilot-178x300.png 178w\" sizes=\"(max-width: 293px) 100vw, 293px\" \/><br \/>\n<\/strong><\/p>\n<h3>Step 4: View Table Properties<\/h3>\n<ul>\n<li>You can view data, columns, and ownership details of existing tables, but editing these properties is not supported.<\/li>\n<\/ul>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-40195\" style=\"border: 1px solid #000000; padding: 1px; margin: 1px;\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2025\/01\/copilot.png\" alt=\"copilot\" width=\"1122\" height=\"616\" srcset=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2025\/01\/copilot.png 1122w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2025\/01\/copilot-300x165.png 300w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2025\/01\/copilot-1024x562.png 1024w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2025\/01\/copilot-768x422.png 768w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2025\/01\/copilot-660x362.png 660w\" sizes=\"(max-width: 1122px) 100vw, 1122px\" \/><\/p>\n<h3>Step 5: Create New Relationships<\/h3>\n<ul>\n<li>You can create <strong>1: N relationships<\/strong> between existing table and newly created table, extending the functionality of their data models.<\/li>\n<\/ul>\n<p><strong> <img decoding=\"async\" class=\"alignnone size-full wp-image-40193\" style=\"border: 1px solid #000000; padding: 1px; margin: 1px;\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2025\/01\/6Visualizing-Data-Models-with-Copilot.png\" alt=\"Visualizing Data Models with Copilot\" width=\"321\" height=\"431\" srcset=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2025\/01\/6Visualizing-Data-Models-with-Copilot.png 321w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2025\/01\/6Visualizing-Data-Models-with-Copilot-223x300.png 223w\" sizes=\"(max-width: 321px) 100vw, 321px\" \/><\/strong><\/p>\n<h3>Step 6: Generate Versatile Applications<\/h3>\n<ul>\n<li>After enhancing the ERD view, you can choose to create selected tables in a <strong>Canvas app<\/strong> or a <strong>Model-driven app<\/strong>, streamlining app development and ensuring greater flexibility.<\/li>\n<\/ul>\n<p><strong> <img decoding=\"async\" class=\"alignnone size-full wp-image-40194\" style=\"border: 1px solid #000000; padding: 1px; margin: 1px;\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2025\/01\/7Visualizing-Data-Models-with-Copilot.png\" alt=\"Visualizing Data Models with Copilot\" width=\"1437\" height=\"713\" srcset=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2025\/01\/7Visualizing-Data-Models-with-Copilot.png 1437w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2025\/01\/7Visualizing-Data-Models-with-Copilot-300x149.png 300w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2025\/01\/7Visualizing-Data-Models-with-Copilot-1024x508.png 1024w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2025\/01\/7Visualizing-Data-Models-with-Copilot-768x381.png 768w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2025\/01\/7Visualizing-Data-Models-with-Copilot-660x327.png 660w\" sizes=\"(max-width: 1437px) 100vw, 1437px\" \/><\/strong><\/p>\n<h4><strong>Conclusion<\/strong><\/h4>\n<p>The enhanced integration of <strong>Copilot<\/strong> with the <strong>ERD<\/strong> view simplifies database design by automating table creation, mapping relationships, and enabling seamless visualization. This boosts productivity, ensures accuracy, and streamlines the development of scalable business applications.<\/p>\n<p><a href=\"https:\/\/www.inogic.com\/services\/ai-solutions\/microsoft-dynamics365-powerplatform-chatgpt-copilot-consulting-services\/?utm_source=inogic-t-blog&amp;utm_medium=copilot&amp;utm_campaign=itblog&amp;utm_id=copilot\" target=\"_blank\" rel=\"noopener\"><img decoding=\"async\" class=\"alignnone wp-image-37491\" src=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/02\/copilot.png\" alt=\"copilot\" width=\"753\" height=\"215\" srcset=\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/02\/copilot.png 700w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/02\/copilot-300x86.png 300w, https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/02\/copilot-660x189.png 660w\" sizes=\"(max-width: 753px) 100vw, 753px\" \/><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Exploring the capabilities of Copilot within Microsoft Dynamics and Power Platform unlocks exciting possibilities for enhancing business application development. A key element of this innovation lies in constructing intricate data models that span multiple tables. The \u2018Create New Tables&#8217; feature in Power Apps, now enhanced to include existing tables, transforms the process by allowing users\u2026 <span class=\"read-more\"><a href=\"https:\/\/www.inogic.com\/blog\/2025\/01\/visualizing-data-models-with-copilot-in-an-erd-view-part-2\/\">Read More &raquo;<\/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":[1],"tags":[3096],"class_list":["post-40187","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-copilot-microsoft-dynamics-crm"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts\/40187","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=40187"}],"version-history":[{"count":0,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts\/40187\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/media?parent=40187"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/categories?post=40187"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/tags?post=40187"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}