Share via

Work with existing tables when visualizing complex data

  • Article

Important

Some of the functionality described in this release plan has not been released. Delivery timelines may change and projected functionality may not be released (see Microsoft policy). Learn more: What's new and planned

Enabled for Public preview Early access General availability
Admins, makers, marketers, or analysts, automatically Jan 2025 - Feb 2025

Business value

By supporting existing tables when visualizing a complex data model, the entity relationship diagram (ERD) data experience will unblock makers to build actual meaningful business solutions on top of their existing data assets. With Copilot assistance, makers can easily find existing tables relevant to their data modeling requirements and build more robust business applications. With the ERD visualization of tables and relationships, makers can review new and existing tables side-by-side and define meaningful connections between them with a simple drag and drop interaction.

Feature details

Are you tired of creating new tables, only to discover that they duplicate existing ones in your environment? Say hello to a smarter way of designing data models using the Copilot-assisted ERD designer. Now, instead of starting from scratch, you can leverage your existing tables to build more robust data models. Here’s how it works: Simply type out your requirements in natural language, and Copilot will craft a multi-table data model that incorporates both new and existing tables. Need to find relevant tables quickly? Copilot’s recommendations have you covered and will locate the right tables in seconds. Once you’ve assembled your tables, switch to the ERD view. There, you can review your new and existing tables side-by-side. While editing existing tables in the ERD view isn't fully supported yet, you can create lookups into the existing tables in a simple drag-and-drop interaction to define meaningful connections between tables.

Geographic areas

This feature will be released into the following Microsoft Azure geographic areas:

  • Germany
  • Norway
  • Singapore
  • South Africa
  • Switzerland
  • United Arab Emirates
  • US GCC
  • US GCC High
  • Sweden
  • Qatar
  • United States
  • Europe
  • Asia Pacific
  • United Kingdom
  • Australia
  • Brazil
  • Canada
  • India
  • Japan
  • France
  • Korea
  • China