Skip to content

Instantly share code, notes, and snippets.

@cbaragao
Created August 23, 2025 01:51
Show Gist options
  • Select an option

  • Save cbaragao/54dc738081ce5e55dc958a3768cedc3b to your computer and use it in GitHub Desktop.

Select an option

Save cbaragao/54dc738081ce5e55dc958a3768cedc3b to your computer and use it in GitHub Desktop.
EVALUATE
VAR __tables =
SELECTCOLUMNS(
INFO.VIEW.TABLES( ),
"ObjectId", [ID],
"ObjectType", "Table",
"Type", "N/A",
"Object", [Name],
"Desc", [Description],
"Hidden", FALSE( ),
"Expressions", [Expression],
"Lineage", [LineageTag]
)
VAR __columns =
SELECTCOLUMNS(
FILTER(
INFO.VIEW.COLUMNS( ),
[DataCategory] <> "RowNumber"
),
"ObjectId", [ID],
"ObjectType", "Column",
"Type", [DataType],
"Object", [Name],
"Desc", [Description],
"Hidden", [IsHidden],
"Expressions", [Expression],
"Lineage", [LineageTag]
)
VAR __measures =
SELECTCOLUMNS(
INFO.VIEW.MEASURES( ),
"ObjectId", [ID],
"ObjectType", "Measure",
"Type", [DataType],
"Object", [Name],
"Desc", [Description],
"Hidden", [IsHidden],
"Expressions", [Expression],
"Lineage", [LineageTag]
)
VAR __relationships =
SELECTCOLUMNS(
INFO.VIEW.RELATIONSHIPS( ),
"ObjectId", [ID],
"ObjectType", "Relationship",
"Type", "",
"Object", [Name],
"Desc",
CONCATENATEX(
{
{ [Relationship] },
{ "; Cross-Filtering: " },
{ [CrossFilteringBehavior] }
},
[Value] & ""
),
"Hidden", "",
"Expressions", "",
"Lineage", ""
)
VAR __union =
UNION( __tables, __columns, __measures, __relationships )
RETURN
__union
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment