Others

How to Enable Edit Data Model in Power Platform Dataflow Gen2

Maira Mehtab Sep 20, 2026 869 views

Question details

A user is unable to access the Edit Data Model feature in Power Platform Dataflow Gen2 despite owning the workspace and successfully connecting to a Data Lake.

Product: Power Platform
Device & OS: not provided
Scenario: Setting up a workspace, configuring Dataflow Gen2, and attempting to edit the data model while using a Power Platform trial license.
Observed behavior: The Edit Data Model option is unavailable or grayed out for the user, whereas other trial users in the same environment can access the feature normally.

Before you start

Ensure you are logged into your Power Platform account with active credentials and verify with your tenant administrator that no recent policy changes have temporarily restricted your workspace access.

Solution 1Recommended

Verify Security Roles and Dataverse Permissions

Ensure you have the required administrative privileges to modify data models within your specific environment.

In Microsoft Power Platform, owning a workspace does not automatically grant you the rights to edit backend data models. You must have specific security roles assigned at the environment level to unlock these capabilities.

Access Admin Center

Navigate to the Power Platform Admin Center and select 'Environments' from the left-hand navigation pane.

Manage Users

Choose the environment where your Dataflow Gen2 is hosted, then go to Settings > Users + permissions > Users.

Assign Security Roles

Select your user profile, click 'Manage roles', and verify that you have either the 'System Administrator' or 'System Customizer' security role assigned.

Sync Delay: If a role was just assigned to you, it may take several minutes for the permissions to propagate across the Power Platform services.

Solution 2

Review Trial License Limitations and Settings

Check if your specific trial license restricts certain advanced modeling features compared to a full premium license.

Solution 3

Validate Data Lake Connection and Seek Support

Confirm that your Data Lake destination mapping is configured correctly and reach out to the community if the issue persists.

Free Microsoft Office alternative

Enhance Your Daily Data Productivity with WPS Office

While Power Platform is excellent for complex enterprise data integrations, you still need a reliable tool for everyday data analysis and reporting. WPS Office offers a lightweight, highly compatible alternative to Microsoft Office, allowing you to handle spreadsheets, documents, and presentations with ease and zero subscription costs.

1. Download the Installer: Visit the official WPS Office website and click the 'Free Download' button.
2. Install WPS Office: Run the downloaded installer file and follow the quick on-screen instructions.
3. Open Your Data Files: Launch WPS Spreadsheets and open your existing .xlsx or .csv data files instantly.

Seamlessly open, edit, and save Microsoft Excel (.xlsx) files without formatting issues.Lightweight application design ensures extremely fast loading times for heavy data reports.Familiar user interface means no learning curve when migrating from Microsoft Office.Built-in robust PDF toolkit for easy conversion of your data analysis reports.

microsoft office alternative - wps office

Frequently Asked Questions

Why is the Edit Data Model button grayed out in Power Platform?

This usually happens due to insufficient Dataverse permissions. Even if you own the workspace, you must have the System Administrator or System Customizer role within the specific environment to modify the data model.

Can Power Platform trial users edit data models in Dataflow Gen2?

Yes, trial users generally have access to this feature. However, availability depends on the exact type of trial license and the configuration settings applied by the tenant administrator.

What should I do if my Data Lake connection fails in Dataflow Gen2?

Verify that your connection credentials have the necessary read/write permissions for the Data Lake. You should also check the destination mapping settings in your Dataflow to ensure there are no configuration errors.

Office Quick Solutions