Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
emlisa
Employee
Employee

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

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

1 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.

 

emlisa_1-1683644873240.png

 

 

 

 

 

View solution in original post

71 REPLIES 71

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!

@emlisa 

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

Fowmy_0-1683709801213.png

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.






Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

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
Super User
Super User

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

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!

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.

This is helpful feedback thank you! One thing to be aware of is for the preview is one current limitation is that we don't support datasets that have been deployed by a deployment pipeline, so you currently will not be able to experiment with editing data models in a deployment pipeline. More information on our limitations can be found here: https://learn.microsoft.com/power-bi/transform-model/service-edit-data-models#considerations-and-lim...

Are there plans to support deployment pipelines? 

We use those for all of our PBI work and love them!

Thank you

Thank you for the feedback! Feedback like this helps us in prioritizing our backlog to help ensure we are enabling the scenarios that are most important to users like you! As part of our long term goals we would like to support editing models in the Service that have been deployed by a deployment pipeline. However this is not something we currently plan to enable in the next couple of months.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors