Documentation in and out of Power BI (data dictionary)

[Anonymous]

I'm sure others have solved these (or found out they're not possible...)

1) To help report-makers, is there an easy way to bulk edit field descriptions in a model, rather than one-by-one typing into each field?

2) To help report-viewers, is there an easy way to create an online data dictionary from a model - eg. exporting all fields, measures and calculated columns (and formulas) into something that can easily turn into a Confluence / Gitbook resource

[edhans · Accepted solution]

For the first, check out Tabular Editor. It lets you bulk edit measures. I do not know if it does the same with field descriptions themselves. It has a scripting language and is quite powerful.

For exporting fields, measures, and calculated columns, use DAX Studio. The following will extract calculated columns.

select * from $SYSTEM.TMSCHEMA_COLUMNS
    where [Type] = 2

That will return the table ID. To find out what that table is, use this:

select * from $SYSTEM.TMSCHEMA_TABLES

To get measures, use

select * from $SYSTEM.MDSCHEMA_MEASURES