export cube details to excel sheet?

[ovonel]

I have several tabular cubes (.bim files) where I am trying to do some documentation in excel.

I would like to find a way to automatically export for a given cube:

• Column name (cube level)
• Column name (source level)
• Table name (cube level)
• Table name (source level)
• Measure with corresponding dax code.

Is there a way I can get all these values with a single click, rather than building it myself by constantly copy pasting to excel?

[MikeJohnsonZA · Accepted solution]

The easiest way is to use Vertipaq Analyzer this tool will connect to any tabular\Power BI model and give you all the data you are looking for and more.

If you would like to build your own solution you want to start with the Dynamic Management Views which allow you to query all the info that you are looking for.