{"id":126916,"date":"2025-01-13T09:26:25","date_gmt":"2025-01-13T17:26:25","guid":{"rendered":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/?post_type=power-apps&#038;p=126916"},"modified":"2025-01-13T09:26:26","modified_gmt":"2025-01-13T17:26:26","slug":"work-with-existing-tables-in-data-workspace","status":"publish","type":"power-apps","link":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/work-with-existing-tables-in-data-workspace\/","title":{"rendered":"Work with existing tables in data workspace"},"content":{"rendered":"\n<p>We are excited to announce that makers can now visualize and manage <strong>existing tables<\/strong> in the ERD table designer, <strong>data workspace<\/strong>! Now, instead of starting from scratch, you can use your existing tables to build more robust data models. Once you\u2019ve assembled your tables, the enhanced ERD view will allow you to review your existing and new tables side-by-side more easily.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"2327\" height=\"1168\" src=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/12\/DWS-M1-overview.jpg\" alt=\"Overview of existing tables in data workspace\" class=\"wp-image-126921\" srcset=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/12\/DWS-M1-overview.jpg 2327w, https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/12\/DWS-M1-overview-300x151.jpg 300w, https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/12\/DWS-M1-overview-1024x514.jpg 1024w, https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/12\/DWS-M1-overview-768x385.jpg 768w, https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/12\/DWS-M1-overview-1536x771.jpg 1536w, https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/12\/DWS-M1-overview-2048x1028.jpg 2048w\" sizes=\"(max-width: 2327px) 100vw, 2327px\" \/><\/figure>\n\n\n\n<p>This update and other data workspace features are now available in <strong>20 languages<\/strong> worldwide. These include English, French, German, Spanish, Dutch, Danish, Italian, Japanese, Portuguese (Brazil), Chinese (Simplified), Czech, Finnish, Greek, Korean, Norwegian (Bokm\u00e5l), Polish, Russian, Swedish, Thai, and Turkish.<\/p>\n\n\n\n<p>For more information about the availability of data workspace, see <a href=\"https:\/\/learn.microsoft.com\/en-us\/power-apps\/maker\/data-platform\/create-edit-entities-portal?tabs=excel#start-with-copilot\">Create and edit tables using Power Apps<\/a>.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"build-data-model-with-existing-tables\">Build data model with existing tables<\/h2>\n\n\n\n<p>You can now add existing tables to your workspace either manually or with <strong>Copilot recommendations<\/strong>. Copilot will suggest the most relevant tables based on the set of tables currently in your workspace. Additionally, when working within a solution, you can also filter to show <strong>only tables in current solution<\/strong>, promoting better ALM practices.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1920\" height=\"970\" src=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/12\/Existing-table-M1-add-tables.gif\" alt=\"Demo - adding existing tables to data workspace \" class=\"wp-image-126924\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"manage-existing-tables-in-the-enhanced-erd-view\">Manage existing tables in the enhanced ERD view<\/h2>\n\n\n\n<p>The ERD view and interaction of data workspace have also been enhanced to streamline the management of your data model. You can now review <strong>column details<\/strong> about your tables, as well as to show and hide columns and relationships of your tables.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1920\" height=\"970\" src=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/12\/Existing-table-M1-show-columns.gif\" alt=\"Demo - managing existing tables in data workspace\" class=\"wp-image-126925\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"limitations\">Limitations<\/h2>\n\n\n\n<p>While we are working on enabling a full editing experience of existing table within data workspace, currently you can only add existing tables to data workspace in <strong>read-only <\/strong>mode. To edit existing table, you will need to open the table in a new tab. This also means that you will not be able to create one-to-many relationships to existing table in the data workspace.<\/p>\n\n\n\n<p>You can find more information about limitations of data workspace in this doc: <a href=\"https:\/\/go.microsoft.com\/fwlink\/?linkid=2297812\">Limitations using the table visual designer<\/a><\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"learn-more-about-data-workspace\">Learn more about data workspace<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/learn.microsoft.com\/en-us\/power-apps\/maker\/data-platform\/create-edit-entities-portal?tabs=excel#create-new-tables\">Create and edit tables using Power Apps &#8211; Power Apps | Microsoft Learn<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/it-pro\/data-workspace-is-now-generally-available\/\">Data Workspace is Now Generally Available! &#8211; Microsoft Power Platform Blog<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/work-with-complex-data-models-in-an-erd-view-assisted-by-copilot\/\">Work with complex data models in an ERD view assisted by Copilot &#8211; Microsoft Power Platform Blog<\/a><\/li>\n<\/ul>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Data workspace, the ERD table designer empowered by Copilot, now supports using existing tables to build your data model.<\/p>\n","protected":false},"author":276,"featured_media":126922,"comment_status":"open","ping_status":"closed","template":"","power-apps-category":[1575,1591,1664],"power-apps-tag":[1538,1574,1590,1665],"coauthors":[2233],"class_list":["post-126916","power-apps","type-power-apps","status-publish","has-post-thumbnail","hentry","power-apps-category-copilot","power-apps-category-dataverse","power-apps-category-uncategorized","power-apps-tag-announcement","power-apps-tag-copilot","power-apps-tag-dataverse","power-apps-tag-power-apps"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Work with existing tables in data workspace - Microsoft Power Platform Blog<\/title>\n<meta name=\"description\" content=\"Data workspace, the ERD table designer empowered by Copilot, now supports using existing tables to build your data model.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/work-with-existing-tables-in-data-workspace\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Work with existing tables in data workspace - Now available in preview\" \/>\n<meta property=\"og:description\" content=\"Data workspace, the ERD table designer empowered by Copilot, now supports using existing tables to build your data model.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/work-with-existing-tables-in-data-workspace\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft Power Platform Blog\" \/>\n<meta property=\"article:modified_time\" content=\"2025-01-13T17:26:26+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/12\/DWS-M1-overview-2.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"2327\" \/>\n\t<meta property=\"og:image:height\" content=\"1168\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 min read\" \/>\n\t<meta name=\"twitter:label2\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data2\" content=\"Travis Shu\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/work-with-existing-tables-in-data-workspace\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/work-with-existing-tables-in-data-workspace\/\",\"name\":\"Work with existing tables in data workspace - Microsoft Power Platform Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/work-with-existing-tables-in-data-workspace\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/work-with-existing-tables-in-data-workspace\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/12\/DWS-M1-overview-1.jpg\",\"datePublished\":\"2025-01-13T17:26:25+00:00\",\"dateModified\":\"2025-01-13T17:26:26+00:00\",\"description\":\"Data workspace, the ERD table designer empowered by Copilot, now supports using existing tables to build your data model.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/work-with-existing-tables-in-data-workspace\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/work-with-existing-tables-in-data-workspace\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/work-with-existing-tables-in-data-workspace\/#primaryimage\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/12\/DWS-M1-overview-1.jpg\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/12\/DWS-M1-overview-1.jpg\",\"width\":2327,\"height\":1168,\"caption\":\"diagram\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/work-with-existing-tables-in-data-workspace\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Power Apps\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Work with existing tables in data workspace\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#website\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/\",\"name\":\"Microsoft Power Platform Blog\",\"description\":\"Innovate with Business Apps\",\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#organization\",\"name\":\"Microsoft Power Platform Blog\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2020\/03\/Microsoft-Logo-e1685482038800.png\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2020\/03\/Microsoft-Logo-e1685482038800.png\",\"width\":194,\"height\":145,\"caption\":\"Microsoft Power Platform Blog\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Work with existing tables in data workspace - Microsoft Power Platform Blog","description":"Data workspace, the ERD table designer empowered by Copilot, now supports using existing tables to build your data model.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/work-with-existing-tables-in-data-workspace\/","og_locale":"en_US","og_type":"article","og_title":"Work with existing tables in data workspace - Now available in preview","og_description":"Data workspace, the ERD table designer empowered by Copilot, now supports using existing tables to build your data model.","og_url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/work-with-existing-tables-in-data-workspace\/","og_site_name":"Microsoft Power Platform Blog","article_modified_time":"2025-01-13T17:26:26+00:00","og_image":[{"width":2327,"height":1168,"url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/12\/DWS-M1-overview-2.jpg","type":"image\/jpeg"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"1 min read","Written by":"Travis Shu"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/work-with-existing-tables-in-data-workspace\/","url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/work-with-existing-tables-in-data-workspace\/","name":"Work with existing tables in data workspace - Microsoft Power Platform Blog","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/work-with-existing-tables-in-data-workspace\/#primaryimage"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/work-with-existing-tables-in-data-workspace\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/12\/DWS-M1-overview-1.jpg","datePublished":"2025-01-13T17:26:25+00:00","dateModified":"2025-01-13T17:26:26+00:00","description":"Data workspace, the ERD table designer empowered by Copilot, now supports using existing tables to build your data model.","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/work-with-existing-tables-in-data-workspace\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/work-with-existing-tables-in-data-workspace\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/work-with-existing-tables-in-data-workspace\/#primaryimage","url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/12\/DWS-M1-overview-1.jpg","contentUrl":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/12\/DWS-M1-overview-1.jpg","width":2327,"height":1168,"caption":"diagram"},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/work-with-existing-tables-in-data-workspace\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/"},{"@type":"ListItem","position":2,"name":"Power Apps","item":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-apps\/"},{"@type":"ListItem","position":3,"name":"Work with existing tables in data workspace"}]},{"@type":"WebSite","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#website","url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/","name":"Microsoft Power Platform Blog","description":"Innovate with Business Apps","publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#organization","name":"Microsoft Power Platform Blog","url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2020\/03\/Microsoft-Logo-e1685482038800.png","contentUrl":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2020\/03\/Microsoft-Logo-e1685482038800.png","width":194,"height":145,"caption":"Microsoft Power Platform Blog"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#\/schema\/logo\/image\/"}}]}},"distributor_meta":false,"distributor_terms":false,"distributor_media":false,"distributor_original_site_name":"Microsoft Power Platform Blog","distributor_original_site_url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog","push-errors":false,"_links":{"self":[{"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/power-apps\/126916"}],"collection":[{"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/power-apps"}],"about":[{"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/types\/power-apps"}],"author":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/users\/276"}],"replies":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/comments?post=126916"}],"version-history":[{"count":17,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/power-apps\/126916\/revisions"}],"predecessor-version":[{"id":127095,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/power-apps\/126916\/revisions\/127095"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/media\/126922"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/media?parent=126916"}],"wp:term":[{"taxonomy":"power-apps-category","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/power-apps-category?post=126916"},{"taxonomy":"power-apps-tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/power-apps-tag?post=126916"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/coauthors?post=126916"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}