Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Next up in the FabCon + SQLCon recap series: The roadmap for Microsoft SQL and Maximizing Developer experiences in Fabric. All sessions are available on-demand after the live show. Register now

Enhance info.view functions

Request to complete info.view functions and add all model assets: 

INFO.VIEW.CALCULATIONGROUPS

INFO.VIEW.CALCULATIONITEMS

INFO.VIEW.PARAMETERS

 

 

Mainly for convenience, but I also have an example use case for this:

to dynamically load a table of model metadata for user verification. 

 

To be specific, I'd like to have this as a calculated table, but it is currently not possible since calculation groups are not exposed in INFO.VIEW functions. 

 

EVALUATE

VAR MeasuresTable =
    SELECTCOLUMNS(
        INFO.MEASURES(),
        "Object Type", "Measure",
        "Category", [DisplayFolder],
        "Name", [Name],
        "Description", [Description],
        "Definition", [Expression]
    )

VAR CalcItemsTable =
    SELECTCOLUMNS(
        INFO.CALCULATIONITEMS(),
        "Object Type", "Calculation Item",
        "Category", "Calculation Perspective",
        "Name", [Name],
        "Description", [Description],
        "Definition", [Expression]
    )

RETURN
    UNION(MeasuresTable, CalcItemsTable)

 

 

Status: New