Anyone who uses PowerBI long enough has had a PBIX with 50-60 measures and it has become time consuming and tedious to mantain. In Excel you can do a quick find/replace to edit several formulas - in ...
Actually All we need is the ability to separate the Model from the data from the visualization in the PBI. I already use Excel, Power Query the PowerBI Object Model and VBA to Author my Data Models in Excel in PowerPivot. (800+ Measures!) from standard analytical Patterns I use he Import from excel in Power BI Desktop to Bring the mode into PowerBI. and then To Service The Problem is that once this is done and you create the Visualization Layer, you cannot go make and make major changes to the Model without recreating the Visualization Model. either way the maintenance of the Model is Time Consuming and Tedious which ever way you go rom there
Recent ideas
Preserve Power BI Semantic Model Measures and Business Metadata When Generating Fabric IQ Ontologies
When Fabric IQ generates an ontology from an existing Power BI semantic model, it should preserve more of the business semantics that organizations have already invested in defining. Today, a semant...