DaveG on 09 Jan 2018 10:55:44
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 PowerBI you need to select each one individually. An "excel-like" interface for editing measures would save a lot of time! This would take PowerBI to the next level regarding productivity. I've prepared a mockup for this as well as a DAX Editor. Let me know what you think.
Mockup: https://i.imgur.com/z6TBOQb.png?1
Administrator on 18 Oct 2022 00:53:09
Update 10/17: This is now in our upcoming roadmap and we will share more details in the coming months. Mo
We've been leaning on the community tools like Tabular Editor, DAX Studio, BISM Normalizer, to provide high-end DAX editing capabilities. We don't have any short-term plans to add more DAX management tools to the product, but we'll be looking at ways to better integrate those tools.
- Comments (128)
- Merged Idea (3)
RE: Measure Management & DAX Editor
For managing and editing measures at scale, Tabular Editor is a must-use tool; it works really well. The only measure related functionality that should be added directly into the Power BI Desktop editor is the ability to search in a report to find where measures are being used - this is currently lacking. Equally, there is a massive need to make Power BI Reports manageable as code, similar to what Tabular Editor has done for Datasets. Structure the Report definitions as a folder structure containing JSON defining visuals, formatting, and measures used.
RE: Measure Management & DAX Editor
TEST
RE: Measure Management & DAX Editor
Great idea!
RE: Measure Management & DAX Editor
only 50 or 60 measures........
RE: Measure Management & DAX Editor
RE: Measure Management & DAX Editor
Some companies don't allow third party software because of security issue. Which mean Power BI is seen as a standalone tool. Mesure & table management is most likely a must have asset to not lose a customer for a competing company
RE: Measure Management & DAX Editor
I'm sure the community tools are great. But, like many I'm in a locked down organisational setting and getting access to these would take an effort of persuasion and promotion I just don't have time for. If the "community tools" are approved by you then PBi should ship with them pre-loaded (or at least available to load).
RE: Measure Management & DAX Editor
The idea "List where a column or measure is used in a report" would be very useful as part of this.
Since the encouraged method is to have a separate model and reporting, it would also be helpful to trace dependencies between reports.
RE: Measure Management & DAX Editor
In SSAS Multi multidimensional, there was an option for editing all measures in script mode.
That was awesome and very easy to mange.
But in power BI it seems Microsoft is going in reverse direction, that kind of functionality is expected by default.
RE: Measure Management & DAX Editor
I don't think that it's ideal to have to lean on community tools to do this, they should be built into Power BI by default.