How to keep the model tidy?

I've been thinking on similar issues.  You can put a description on a Power Query, but not on a Measure.  It seems to have been raised as an idea for over 12 months but doesn't have many votes yet - see Idea 9423663: Enhance Metadata - Descriptions

There's a related (older) discussion on PowerPivotPro Forum: Organizing Your Measures With a “Dummy” Table – Guest Post From Eric Hutton  This gives you a tidier view of your measures and allows for simpler cleanup of test measures etc., but also breaks the PivotTable drillthrough feature in Excel - on double-click, you drill into your measures table, not the data table.  And it still doesn't track your measure description.

And surfacing this metadata to users is another step.  I've previously used a SharePoint list to track measures from a business perspective (inc. the description of what a measure really means, custodian etc.)  It's useful as a simplistic business-side data dictionary with multi-user access, version control etc., and COULD be queried as a data source by your BI solution.  But it doesn't simply or reliably link to the technical metadata (e.g. DAX) for the published solution even if extracted via Dax Studio etc.

Bottom line: I think there's a gap in maintaining and publishing BI solution metadata, inc. measure descriptions.

Hi faludigabor,

Please also take a look at the article below:

Data Import Best Practices in Power BI

Regards