Dax Studio for Documentation

[Jenil_Gala]

Hi all,

I am using Dax Studio for documenting my Columns, Tables and Measures of the reports. I want to export all of this in one go in one excel (linked version to update it automatically). Please help. 

[Jenil_Gala]

Hi,

thanks for your reply. This works, but it only gives me calculated columns, calculated tables and & measures. 

I want to document my existing columns, tables, measures and all the caculated ones. How to query that?

Thanks.

[FBergamaschi]

I never tried that

Try

SELECT DISTINCT([OBJECT_TYPE]), [OBJECT], [EXPRESSION]
from
$SYSTEM.DISCOVER_CALC_DEPENDENCY

Best

If this helped, please consider giving kudos and mark as a solution

@me in replies or I'll lose your thread

consider voting this Power BI idea

Francesco Bergamaschi

MBA, M.Eng, M.Econ, Professor of BI

[Jenil_Gala]

Hi,

This doesnt work. Its just givine me list of only calculated columns, measures & tables. In your query-

from 

$SYSTEM.DISCOVER_CALC_DEPENDENCY

this is taking Calc_Dependency only. 

I want list of all columns, measures and tables. 

[FBergamaschi]

EVALUATE

    INFO.VIEW.COLUMNS()

EVALUATE

    INFO.VIEW.MEASURES()

EVALUATE

    INFO.VIEW.TABLES()

EVALUATE

    INFO.VIEW.RELATIONSHIPS()

these work on DAX query view in PBI Desktop or in DAX STudio connected to the semantic model

If this helped, please consider giving kudos and mark as a solution

@me in replies or I'll lose your thread

consider voting this Power BI idea

Francesco Bergamaschi

MBA, M.Eng, M.Econ, Professor of BI

[Jenil_Gala]

Hi,

Thanks for your reply. This query gives me list of columns and tables, but it doesnt include measures in the same list.

[FBergamaschi]

I am afraid there is no specific way to obtain what you want in a single list

[FBergamaschi · Accepted solution]

launch the following query in DAX studio after setting the  output to a static Excel file that will be saved wherever you want at the end of the query execution:
SELECT DISTINCT([OBJECT_TYPE]), [OBJECT], [EXPRESSION]
from
$SYSTEM.DISCOVER_CALC_DEPENDENCY
WHERE
[OBJECT_TYPE]='CALC_COLUMN' OR [OBJECT_TYPE]='MEASURE' OR [OBJECT_TYPE]='CALC_TABLE'
Once the query is launched, DAX studio allows you to export the result to an Excel file

By the way you can also use Info DAX functions in Power BI Desktop as an alternative

If this helped, please consider giving kudos and mark as a solution

@me in replies or I'll lose your thread

consider voting this Power BI idea

Francesco Bergamaschi

MBA, M.Eng, M.Econ, Professor of BI