Forum Discussion

Jenil_Gala's avatar
Jenil_Gala
Frequent Visitor
1 year ago
Solved

Dax Studio for Documentation

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. 

Need Help
Tips and Tricks
  • FBergamaschi's avatar
    FBergamaschi
    1 year ago

    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

7 Replies

  • FBergamaschi's avatar
    FBergamaschi
    Super User
    1 year ago

    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

  • Jenil_Gala's avatar
    Jenil_Gala
    Frequent Visitor
    1 year ago

    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's avatar
      FBergamaschi
      Super User
      1 year ago

      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's avatar
        Jenil_Gala
        Frequent Visitor
        1 year ago

        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.