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

Thank you for coming back to me Dane, tried something similiar but your post is better -  I suppose I could use infor .view for everything else except source and have this table - copy it out and into a sharpoint location with the rest of the data. It would be interesting to know if I could get the report name to populate in this table or link this up further some how.

danextian's avatar
danextian
Super User
1 year ago

Sorry. What do you mean by report name? DAX Query is local to the semantic model.