Share your thoughts on the new data model editing in the Power BI service feature (preview)

[emlisa]

Hit Reply to tell us what you think about the new Data Model Editing in the Power BI Service feature so we can continue to improve.

For example:

• What changes would you like to see?
• If you turned off the Workspace level preview switch, why?
• If you turned off the admin switch, why?
• Any suggestions for additional settings or capabilities?

Thanks,

-Power BI team

To read more about the feature see the announcement in the Power BI Product Blog

[Jellbrae]

"As you make changes to your data model, your changes will be automatically saved. Changes will be permanent with no option to undo."

Is the "undo" feature (eg. like the applied steps in Query Mode but then on a higher level) still to come in the next few weeks or months or is it something that is not considered? 

[emlisa]

The capability to revert a data model to a previous point in time is something we are investigating supporting for future milestones. This type of functionality will realistically take time to implement and will not land in the near future. Do you anticipate needing to "undo" changes regularly? Do you anticipate wanting to do this more in a single session using functionality like Ctrl+Z, or across sessions using functionality such as version history? We are interested in learning more about your feedback on this topic!

[JoeCronk]

I'm not seeing the option to turn this feature on in our workspaces.  Has this been fully released yet?

Edit your data model in the Power BI Service (Preview) | Microsoft Power BI Blog | Microsoft Power B...

[emlisa]

This has been released to all regions. Are you still not seeing this feature for your workspace? If so what type of workspace are you testing and in what region? The one thing to be aware of is not all datasets in pro workspaces are yet fully supported in the following regions. Information about this limitation will regularly be updated in our documentation found here: https://learn.microsoft.com...
Brazil South
Canada Central
Central US
East US
East US 2
India Central
Japan East
North Central US
North Europe
South Africa North
South Central US
Southeast Asia
UAE North
UK South
West US
West US 2

[Kajkoo]

Hello @emlisa , I also don't see this option yet for our premium workspaces. I'm located in Czech Republic (Central Europe).

Any advices how to turn this on?
Thanks

[emlisa]

Thank you for bringing this to our attention! This should be available in all regions for Premium workspaces, we will investigate if there are any issues. 

[JoeCronk]

I'm still not seeing this option.  We are using a Premium workspace and I'm based in North America.

[emlisa]

I am sorry to hear that you do not see this option, do you still not see the workspace setting? This is publicly available in North America regions.

[JoeCronk]

The option is available now.  It finally appeared for me about 2 weeks ago. 

[emlisa]

Glad to hear this was resolved! Please let us know if you have any additional questions or feedback!

[Fowmy]

hi @emlisa 

I am excited to try this out!

I enbaled the feature as instructed yet, the option "Open Data Model" is disabled for me.

My region is West Europe (Netherlands)

[emlisa · Accepted solution]

I am glad to hear that you are excited to try this out! I suspect that the dataset you are trying to test falls under one of our limitations and that is why the 'Open data model' button is disabled. You can see a full list of our limitations for this experience here in our documentation: Edit data models in the Power BI service (preview) - Power BI | Microsoft Learn

To see which limitation your dataset falls under you can do the following steps:

Hover over the Open data model button in the dataset details page. This displays a tooltip indicating which limitation is causing the Open data model button to be disabled.

[arpost]

I love being able to edit semantic models in the Service as that makes it much easier to manage centralized models. That said, I've found you can't use this feature with the Fabric Data Warehouse as some tables that get added are broken when you add them.

What's odd is not all tables have this problem; some in certain schemas work just fine while others fail. Is this being addressed?

Here's my community post about this behavior (link).

[emlisa]

Thank you for this feedback! I am happy to hear that being able to edit semantic models in the Service has made it easier for you to manage centralized models. Regarding the issue that you reported we are currently investigating this issue. We are working to address this and will follow up on the community post you made on this topic. 

[GabrielSantos]

Here's what I was hoping this feature would be able to do.

1. Enable effective parallel development on the dataset layer. We currently use Tabular Editor desktop version for versioning, but parallel development is still a challenge because we can't perform all required tasks solely with Tabular Editor (adding new tables, defining relationships, etc.). Therefore, we perform these tasks in Power BI Desktop and serialize the model. This is a major bottleneck for parallel development because any change a developer does on the .PBIX renders the other developer's .PBIX out of date, and there's no effective way to pull a .PBIX while retaning any changes you may have made. 
2. Support self-service report authors in inspecting the model relationships without having to use Power BI desktop. While there is an ability to author reports directly in the Power BI service, this functionality is severely limited with any degree of model complexity. Not being able to inspect the model relationsihps introduces confusion to the end users as they may inadvertantly create a visual with invalid relationships. As there is no way to inspect the relationships in the service, our users have to install and user Power BI Desktop.

[emlisa]

Thank you for the feedback! It is helpful to hear what scenarios are most important to you.

1. We support mutple authors editing the same data model with this preview which is a first step towards helping address parallel development. It is helpful for us to know that parallel developement is something important to you!

2. Our previous allows users to view all relationships for their model by opening the data model associated with the report. Report authors can see all the model relationships within the service without having to open desktop as long as they have contributor access to the dataset.

Hope this helps! Thank you again for taking the time to share what scenarios you are most important to you!

[Fowmy]

@emlisa 

Thanks for the clarification. The limitation in my model is that I have applied incremental refresh ☹️

So, when can we expect these limitations to be lifted?

• Datasets that have incremental refresh.
• Datasets that have been deployed by a deployment pipeline.
• Datasets modified by an XMLA endpoint.
• Datasets that haven't yet been upgraded to enhanced metadata format. You can upgrade to enhanced metadata format by opening the corresponding pbix in Desktop and republishing.
• Datasets that have automatic aggregations configured.
• Datasets that have a live connection.

[emlisa]

There are a lot of improvements we are working on for this experience to support additional scenarios and remove limitations. Removing these limitations will be technically difficult to implement and will take time, because of this realistically these limitations will not land soon. However, removing these limitations is on our radar and is something we are long-term working towards. Feedback like what you shared is helpful in shaping our roadmap, thank you!

[AlexisOlson]

This is a great feature but I'm not sure how to include it in a source control workflow. Does anyone have suggestions?

[emlisa]

We are investigating various source control options for upcoming releases. One related capability we are investigating is supporting version history for datasets in the service. Would version history address your highest priority source control needs? I am interested in learning more about what functionality is most important to you for source control with editing data models!

[AlexisOlson]

My priority is to have fine grain control over what changes get deployed. With the desktop version, I can tinker around and choose not to save or not to publish any changes. I always do a diff on the TMSL folder structure version of my model and review any changes before I republish an important model.

In contrast, any changes made in the service are automatically immediately applied without any review steps. This fundamentally changes the workflow. I think it might work if I'm editing a model in the dev workspace of a deployment pipeline (so that changes can be reviewed before deploying to test and prod) but I haven't yet experimented with this.