Skip to main content
Microsoft Idea

Power BI

Under Review

Annotate and enrich the metadata of SSAS models published to PowerBI service

Vote (14) Share
Jesse Colglazier's profile image

Jesse Colglazier on 25 Feb 2015 03:39:24

When connecting to a model the user should be able to see the following information to help them better understand what they are connecting to and whether the data is applicable to them:
• quality of data
• certification state of data
• steps to obtain access to data
• size of underlying data model and speed of data
• documentation for the data (if data model, fields and table overviews)

Comments (1)
Jesse Colglazier's profile image Profile Picture

Tas on 05 Jul 2020 22:45:33

RE: Annotate and enrich the metadata of SSAS models published to PowerBI service

In the SSAS tabular model you have a description field for each measure, this would be useful to help both document measure, and provide more info to end users. We can document measure internally with comments, but this is not visible or helpful to end users. I have a separate database of measures, descriptions, definitions, prpurpose etc, and can pull this into the model as a table, but I can't relate the rows in it to the measures in the model directly.

The only work around I have is to create URLs for the measures in a separate app, and then expose these via hand crafted URLs on report pages etc that point people to the separate documentation.

So having these sorts of capabilities built in would be great.