Metadata reporting

Analysis Services DMVs are available to retrieve the descriptions applied to datasets and related information. These DMVs can be leveraged for both simple, ad hoc extracts via common dataset tools, such as DAX Studio, as well as more robust and standardized reports in Power BI or Excel.

Official documentation of Analysis Services DMVs, including a reference and description of each DMV, query syntax, and client-tool access, is available via the following link: http://bit.ly/2A81lek.

The following query can be used to retrieve the measures in a dataset with descriptions as well as their DAX expression:

SELECT 
       [Name] as [Measure Name]
  ,    [Description] as [Measure Description] 
  ,    [Expression] as [DAX Expression]
FROM
$SYSTEM.TMSCHEMA_MEASURES
WHERE LEN([Description]) > 1
ORDER BY [NAME]; 

The WHERE clause in this query ensures that only measures with a description applied are returned. Removing or commenting out this clause (for...