This update and other data workspace features are now available in 20 languages worldwide. These include English, French, German, Spanish, Dutch, Danish, Italian, Japanese, Portuguese (Brazil), Chinese (Simplified), Czech, Finnish, Greek, Korean, Norwegian (Bokmål), Polish, Russian, Swedish, Thai, and Turkish.

For more information about the availability of data workspace, see Create and edit tables using Power Apps.

Build data model with existing tables

You can now add existing tables to your workspace either manually or with Copilot recommendations. 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 only tables in current solution, promoting better ALM practices.

Manage existing tables in the enhanced ERD view

The ERD view and interaction of data workspace have also been enhanced to streamline the management of your data model. You can now review column details about your tables, as well as to show and hide columns and relationships of your tables.

Limitations

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 read-only 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.

You can find more information about limitations of data workspace in this doc: Limitations using the table visual designer

Learn more about data workspace

• Create and edit tables using Power Apps – Power Apps | Microsoft Learn
• Data Workspace is Now Generally Available! – Microsoft Power Platform Blog
• Work with complex data models in an ERD view assisted by Copilot – Microsoft Power Platform Blog

The post Work with existing tables in data workspace appeared first on Microsoft Power Platform Blog.

Extended language and geo availability

As part of general availability, data workspace is now accessible in 9 different languages worldwide, including English, French, German, Spanish, Dutch, Danish, Italian, Japanese, and Portuguese. This allows more users around the world to take advantage of the enhanced data experience in their native language. We’ve also ensured that this feature complies with geo availability policies. Thus, it can be accessed reliably across regions, expanding the feature’s global reach.

Latest GPT models for enhanced Copilot assistance

To elevate your experience, we are now using the latest GPT models, GPT 4o mini and GPT 4o, in this GA release. These models bring enhanced AI-driven interactions, enabling more precise data model generation, improved natural language processing, and greater overall performance in Copilot’s ability to understand and act on your requests.

Access data workspace from within your solution

One of the major new features in this GA release is the ability to access the data workspace directly from within your solutions. This improvement streamlines how tables and apps are created and managed. It ensures they adhere to your solution-specific standards and governance from the very beginning. When you access the workspace from your custom solution, any tables and apps created using the data workspace will automatically apply the correct solution prefixes. They will also reside directly within your solution, removing the need for time-consuming adjustments and manual alignment.

Data workspace is ready to create model-driven apps

In addition to its data modeling capabilities, data workspace now enables you to create not only modern canvas apps but also model-driven apps directly from the workspace, all based on the data model you build.

• Canvas apps offer a highly customizable, design-first experience where you have full control over the app’s layout, appearance, and functionality. You can use drag-and-drop controls to build your apps. You can then configure them with Power Fx, making it easier to tailor apps exactly to your business needs.
• Model-driven apps, on the other hand, provide a more structured approach to app development. The data model itself determines most of the layout and user interface. With the new functionality in the workspace, you can now create model-driven apps directly from the data model you’ve designed. Once your data relationships and entities are in place, you can automatically generate a model-driven app. The app will reflect the structure and complexity of your data, without needing to be configured from scratch.

These new capabilities streamline the app-building process significantly. Whether you want the creative freedom of canvas apps or the structured approach of model-driven apps, the workspace now supports both. This makes it easier than ever to create business apps tailored to your data model.

Learn more about data workspace

Looking Ahead: This GA release is just the beginning. We continuously meet Microsoft’s promise for Copilot availability and expand the product’s capabilities based on your needs. Stay tuned for future updates, including more language support, integrations, advanced customization options, and even smarter Copilot interactions.

Try It Now: The new data experience is now live and available to all users. We invite you to try it out, explore the possibilities, and let us know what you think. Access the documentation below to learn more.
Create new tables
Build apps through conversation

The post Data Workspace is Now Generally Available! appeared first on Microsoft Power Platform Blog.

Extended language and geo availability

As part of general availability, data workspace is now accessible in 9 different languages worldwide, including English, French, German, Spanish, Dutch, Danish, Italian, Japanese, and Portuguese. This allows more users around the world to take advantage of the enhanced data experience in their native language. We’ve also ensured that this feature complies with geo availability policies. Thus, it can be accessed reliably across regions, expanding the feature’s global reach.

Latest GPT models for enhanced Copilot assistance

To elevate your experience, we are now using the latest GPT models, GPT 4o mini and GPT 4o, in this GA release. These models bring enhanced AI-driven interactions, enabling more precise data model generation, improved natural language processing, and greater overall performance in Copilot’s ability to understand and act on your requests.

Access data workspace from within your solution

One of the major new features in this GA release is the ability to access the data workspace directly from within your solutions. This improvement streamlines how tables and apps are created and managed. It ensures they adhere to your solution-specific standards and governance from the very beginning. When you access the workspace from your custom solution, any tables and apps created using the data workspace will automatically apply the correct solution prefixes. They will also reside directly within your solution, removing the need for time-consuming adjustments and manual alignment.

Data workspace is ready to create model-driven apps

In addition to its data modeling capabilities, data workspace now enables you to create not only modern canvas apps but also model-driven apps directly from the workspace, all based on the data model you build.

• Canvas apps offer a highly customizable, design-first experience where you have full control over the app’s layout, appearance, and functionality. You can use drag-and-drop controls to build your apps. You can then configure them with Power Fx, making it easier to tailor apps exactly to your business needs.
• Model-driven apps, on the other hand, provide a more structured approach to app development. The data model itself determines most of the layout and user interface. With the new functionality in the workspace, you can now create model-driven apps directly from the data model you’ve designed. Once your data relationships and entities are in place, you can automatically generate a model-driven app. The app will reflect the structure and complexity of your data, without needing to be configured from scratch.

These new capabilities streamline the app-building process significantly. Whether you want the creative freedom of canvas apps or the structured approach of model-driven apps, the workspace now supports both. This makes it easier than ever to create business apps tailored to your data model.

Learn more about data workspace

Looking Ahead: This GA release is just the beginning. We continuously meet Microsoft’s promise for Copilot availability and expand the product’s capabilities based on your needs. Stay tuned for future updates, including more language support, integrations, advanced customization options, and even smarter Copilot interactions.

Try It Now: The new data experience is now live and available to all users. We invite you to try it out, explore the possibilities, and let us know what you think. Access the documentation below to learn more.
Create new tables
Build apps through conversation

The post Data Workspace is Now Generally Available! appeared first on Microsoft Power Platform Blog.

What’s more, Copilot will be at your service, ready to handle the tedious and repetitive tasks such as populating sample data, configuring table metadata, or updating columns, freeing you up to focus on creativity and strategy. With this new data experience, a single sentence can be transformed into a comprehensive multi-table data model, complete with a Copilot-ready business app, streamlining your workflow like never before.

Accessing the ERD data experience

The feature is currently available in English. To access it, simply enable Copilot (preview) features for your environment. Then, go to the Power Apps home page and turn on the ‘Try the new data experience’ toggle.

Once enabled, the new data experience can be accessed through various entry points. This includes the home page, tables page, app designers, and more. Essentially, it’s available anywhere you can create new tables today, offering a seamless integration into your workflow.

Multi-table in ERD view

The new data experience now enables you to interact with multiple tables in an ERD view through intuitive drag-and-drop actions. This visual ERD framework allows for a clear understanding of how your tables interconnect to form a robust data model. Moreover, it simplifies table and relationship management, empowers you to establish relationships between tables with just a few clicks.

Data drawer

In addition to the ERD view, the new data experience introduces a data drawer, which allows you to view the schema and tabular representation of your data model side by side. The data drawer enables direct editing of tables—columns, rows, table properties, and more. For an immersive experience, you can also switch to full-screen mode to concentrate solely on individual tables.

Bringing data for a unified model

You now have the power to create tables from a variety of sources, including natural language, Excel files, SharePoint lists, or from the ground up. Effortlessly establish relationships between these tables and observe as they amalgamate into a singular, comprehensive data model. This integration not only simplifies data management, but also provides a holistic view of your data ecosystem, enabling the creation of more meaningful business apps.

Describe new tables

You can create tables by simply describing them. Whether you need one table or multiple, Copilot will generate the necessary tables along with relationships based on your instructions. Specify the number of columns for each table, and whether you want relationships included when requesting a multi-table data model. Copilot takes your configurations and turns them into reality.

Import an Excel file or SharePoint list

You can also bring your own data by importing from external sources such as Excel or SharePoint lists. Copilot streamlines the setup by recommending table names, descriptions, column data types and formats, as well as column headers, tailored to the data you upload. After the import, you’ll have the opportunity to review and tweak the tables, ensuring they accurately reflect your data and serve your needs effectively.

A full Copilot experience

Copilot is ready to assist you with a wide array of tasks beyond just creating tables. It can populate your tables with sample data:

Suggest and create new columns for your table:

Or even help you establish relationships between any two tables:

These capabilities extend to tables created from all sources, ensuring a fully Copilot-powered experience for managing your data model. To get started, select ‘View prompts’ and explore the predefined Copilot prompts that can help bootstrap your data model.

Learn more about the ERD data experience

• Create new tables (preview)
• Build apps through conversation (preview)

The post Work with complex data models in an ERD view assisted by Copilot appeared first on Microsoft Power Platform Blog.

Create with the option that best suits your need

The updated tables page experience provides a variety of options for you to get started with creating your table. You can select one of the options as main tiles on the tables page, which will then load the corresponding create table experience for you to proceed with table creation.

You can now create new tables through conversation or Excel file upload. By selecting Describe the new table, you will be able to create new tables prepopulated with sample data through generative AI conversation powered by Copilot. On the other hand, selecting Upload an Excel file will allow you to create new table from your uploaded Excel data in just a couple of clicks. You can also Start with a blank table or Create a virtual table by selecting the tiles respectively. Note that Copilot capabilities are currently only available in U.S. region but coming soon to more regions.

If you are an advanced maker and would like to have more control over your table metadata by configuring the advanced table properties, select Set advanced properties, which will then open the create table panel for you.

Learn more

• Create and edit tables using Power Apps

The post Introducing new ways of creating tables appeared first on Microsoft Power Platform Blog.

What’s different from the current experience?

Today there are two approaches to import your data from Excel to Dataverse:

1. You can use the Import data from Excel option on Tables page. For this to work, you need to first create the table, set up the table schema correctly, create columns with appropriate data types, then manually map these columns one after another to your Excel file.
2. You can also use Dataflow to take care of the table creation and data import. However, to be able to use Dataflow, you need to be familiar with Power Query, which requires a different skillset from Dataverse. Furthermore, importing with Dataflow only allows the configuration of a subset of the complete data types supported by Dataverse. This might increase frictions as you set up your business logic and apps down the road.

With the new import data from Excel experience, there’s no need to go through the manual creation of table and column prior to data import, nor the need to learn about Power Query — all you need is upload your Excel file, review and edit the table schema, then see your table and app created for you in real time.

How does the new experience work?

To use the new import data from Excel experience, you’ll need to enable the new maker portal home page. Once you are on the new home page, simply select Start with data, then Upload an Excel file. After uploading your Excel file, you will see a preview of your table, where you can review and edit your table schema before selecting Create app to create a Dataverse table and responsive canvas app.

Once you select Create app, we will create a Dataverse table based on your table configuration from the previous step, and then generate a responsive canvas app using that table. Depending on the size of your data, you might not see all of your data in the canvas app right away. This is because we want to unblock the creation of your app by uploading the top 20 rows of data first. The remaining data will be uploaded in the background, and you can always proceed to table hub or table designer to review the progress.

Import your data more easily with Copilot

When Copilot is enabled, it will assist with your table creation by generating table name, table description, column data type and format, as well as column header based on the data you upload. Copilot is also able to detect repetitive values in a column and infer that as a choice column, in the meantime generating choice options automatically to save the manual effort.

When a table is generated leveraging Copilot, a card will show up to the left, indicating AI has assisted with the creation of this table. You can also give us feedback on how Copilot is doing so we can further improve our modeling in the future.

What’s next?

You can learn more about the experience here.

This is just the first step of the new import from Excel experience. We are actively working on supporting more scenarios at scale towards general availability, and we’d love your feedback!

The post Introducing an easier than ever experience to import data from Excel appeared first on Microsoft Power Platform Blog.

Working in table hub and table designer

The Update forms and views feature is now available in both table hub and table designer.

To add columns to your forms and views, simply start with adding new or existing columns to the table layout. Each time when a new or existing column is added, a red dot will show up next to the Update forms and views option to remind you there’re columns to be updated in your forms and views.

Once you’re done with the update, select Update forms and views to configure what forms and views should be updated. By default, all main forms as well as public, advanced find, associated, and quick find views from this table are selected for the update. You can also review and edit what columns to be added to your forms and views in the Add these columns dropdown.

After selecting Update in the flyout, selected columns will be added to the first section of the first tab of selected forms:

And selected columns will also be added to the end of selected views:

Working in the modern app designer

You can also use the Update forms and views feature when working with tables in the modern app designer. Besides all the capabilities mentioned above in table hub and table designer, there’s one additional feature that allows you to directly update your forms and views as you close the inline table designer. Then, as soon as you select Publish to publish your forms and views, you will be able to see the latest changes reflected in your modern app right away! ?

Learn more

• Update forms and views using table designer

The post Update forms and views more conveniently with table designer appeared first on Microsoft Power Platform Blog.

The enhanced environment picking experience makes it easier to find the right environment to work with. For example, makers can now directly tell environments with Dataverse apart from those without Dataverse, as well as environments where they have sufficient maker and data permission apart from those where they don’t. This enables makers to select the right environments where they can build modern apps successfully.

Grouping of environments

We have divided the environments into two groups in the enhanced environment picking experience: Build apps with Dataverse and Other environments.

Environments shown under Build apps with Dataverse group are all provisioned with Dataverse and will guarantee that makers have both app making and table CRUD permissions in those environments. In other words, makers will be able to build modern apps, manage tables, and leverage the breadth of features Dataverse has to offer without any friction in those environments.

Environments shown under Other environments group, on the other hand, could have various limitations. For example, those environments might not have Dataverse, or makers might not have sufficient app making or table CRUD permissions.

It is highly recommended for new makers to start exploring with Power Apps in environments under the Build apps with Dataverse group so they can experience the full capabilities of Power Apps without any friction.

Filtering and searching environments

Besides searching, we have also added filtering capabilities to the enhanced environment picking experience. Makers can now filter the list of environments by Your role, Data platform, and Environment type.

The Your role filter determines what role and level of permissions makers have in each environment. For example, if a maker has Maker with data access role in an environment, they will be able to build apps and create/edit tables in that environment without any issue. Whereas if maker has Shared app contributor role in an environment, they will only be able to edit apps that have been shared with them in that environment. You can learn more about role filtering through this doc.

Besides filtering by roles, makers can also filter by Data platform and Environment type. Data platform suggests if the environment has been provisioned with Dataverse or not, while Environment type indicates the purpose of the environment and determines its characteristics.

The post Making it easier to work with the right environment appeared first on Microsoft Power Platform Blog.