Don't miss your chance to take the Fabric Data Engineer (DP-600) exam for FREE! Find out how by attending the DP-600 session on April 23rd (pacific time), live or on-demand.
Learn moreNext 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
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)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.