Forum Discussion

Jitmondo's avatar
Jitmondo
Helper III
1 year ago
Solved

Function like info.View but instead shows data source for each table/query?

Hi all,   Currently collating a data dictionary template, great as it auto updates using some dax with variables and union. Produces a Data Dictionary table that we can extract and link to somewhe...
Need Help
  • danextian's avatar
    danextian
    1 year ago

    Hi Jitmondo 

     

    I don't think such a function exits. You can use INFO.PARTITIONS() in DAX query view to view query definition of a table (DAX or M) and identify the source from there.

    EVALUATE
SELECTCOLUMNS (
    INFO.PARTITIONS (),
    "Table Name", [Name],
    "Query Definition", [QueryDefinition],
    "Source Category",
        IF (
            CONTAINSSTRING ( [QueryDefinition], "let Source" )
                || LEFT ( [QueryDefinition], 3 ) = "let",
            "M",
            "DAX"
        )
)

     

Jitmondo's avatar
Jitmondo
Helper III
1 year ago

Sorry - I mean when I combine this across multiple reports(planning to) I will need to differentiate them with identifier like report name, I suppose I could just manually insert each time but was looking for something to automate it completely. Right now we are using Dax Studio to populate a dictionary which covers source, tables,  columns, and measures - but is done in four files - I know there is a way to automate with power shell but not so great with it 🙂 Thanks again I will try the above in my solution.