Forum Discussion
DMV Column Output Definitions and Options
Hi ACraig08,
Thank you for the question
To assist you, I will clarify both the meaning of the columns and how to interpret the values presented.
$SYSTEM.TMSCHEMA_ANNOTATIONS
This DMV provides annotations, which are custom metadata linked to model objects. Below is an explanation of the columns and their significance:
Below are the Column and Descriptions:
ID --- Unique identifier for the annotation.
ObjectID --- ID of the object the annotation is attached to.
ObjectType --- Type of object (e.g., Column, Table, Measure).
Name --- The annotation's name, such as SummarizationSetBy or PBI_FormatHint.
Value --- The actual metadata value — often a string or JSON.
Examples of Name values:
SummarizationSetBy: Indicates how summarization was set (e.g., user or system).UnderlyingDateTimeDataType: Specifies the original data type (e.g., DateTime64).
PBI_FormatHint: Power BI-specific formatting hints.
$SYSTEM.DISCOVER_CALC_DEPENDENCYThis DMV showsdependencies between calculated objects (like measures, calculated columns).
Below are the Column and Descriptions:OBJECT_ID --- ID of the calculated object (e.g., a measure).
OBJECT_TYPE --- Type of the object (e.g., 1 = Table, 2 = Column, 3 = Measure, etc.).
REFERENCED_OBJECT_ID --- ID of the object it depends on.
REFERENCED_OBJECT_TYPE --- Type of the referenced object.
Common OBJECT_TYPE values:
1: Table
2: Column
3: Measure
4: Hierarchy
5: KPI
6: Relationship
7: Role
8: Calculation Group
9: Calculation Item
These values are not always documented in one place, but they are inferred from community knowledge and tools like DAX Studio or Tabular Editor.
You can refer to the official Microsoft documents below, which you may find helpful.
Dynamic Management Views (DMVs) in Analysis Services | Microsoft Learn
[MS-SSAS-T]: SQL Server Analysis Services Tabular Protocol | Microsoft Learn
Solved: Re: Querying DMV Data Types in DAX Studio - Microsoft Fabric CommunityIf my response was helpful, consider clicking "Accept as Solution" and give us "Kudos" so that other community members can find it easily. Let me know if you need any more assistance!
Thank you,
Sahasra
Community Support Team.
Hi ACraig08,
Thank you for the question
To assist you, I will clarify both the meaning of the columns and how to interpret the values presented.
$SYSTEM.TMSCHEMA_ANNOTATIONS
This DMV provides annotations, which are custom metadata linked to model objects. Below is an explanation of the columns and their significance:
Below are the Column and Descriptions:
ID --- Unique identifier for the annotation.
ObjectID --- ID of the object the annotation is attached to.
ObjectType --- Type of object (e.g., Column, Table, Measure).
Name --- The annotation's name, such as SummarizationSetBy or PBI_FormatHint.
Value --- The actual metadata value — often a string or JSON.
Examples of Name values:
SummarizationSetBy: Indicates how summarization was set (e.g., user or system).
UnderlyingDateTimeDataType: Specifies the original data type (e.g., DateTime64).
PBI_FormatHint: Power BI-specific formatting hints.
$SYSTEM.DISCOVER_CALC_DEPENDENCY
This DMV showsdependencies between calculated objects (like measures, calculated columns).
Below are the Column and Descriptions:
OBJECT_ID --- ID of the calculated object (e.g., a measure).
OBJECT_TYPE --- Type of the object (e.g., 1 = Table, 2 = Column, 3 = Measure, etc.).
REFERENCED_OBJECT_ID --- ID of the object it depends on.
REFERENCED_OBJECT_TYPE --- Type of the referenced object.
Common OBJECT_TYPE values:
1: Table
2: Column
3: Measure
4: Hierarchy
5: KPI
6: Relationship
7: Role
8: Calculation Group
9: Calculation Item
These values are not always documented in one place, but they are inferred from community knowledge and tools like DAX Studio or Tabular Editor.
You can refer to the official Microsoft documents below, which you may find helpful.
Dynamic Management Views (DMVs) in Analysis Services | Microsoft Learn
[MS-SSAS-T]: SQL Server Analysis Services Tabular Protocol | Microsoft Learn
Solved: Re: Querying DMV Data Types in DAX Studio - Microsoft Fabric Community
If my response was helpful, consider clicking "Accept as Solution" and give us "Kudos" so that other community members can find it easily. Let me know if you need any more assistance!
Thank you,
Sahasra
Community Support Team.
Hi ACraig08,
We wanted to follow up since we haven't heard back from you regarding our last response. We hope your issue has been resolved.
If my answer resolved your query, please mark it as "Accept Answer" and give Kudos if it was helpful.
If you need any further assistance, feel free to reach out.
Thank you for being a valued member of the Microsoft Fabric Community Forum!
HI ACraig08,
Just wanted to check regarding your question. We haven’t heard back and want to ensure you're not stuck. If you need anything else or have updates to share, we’re here to help!
Thank you.Hi ACraig08,
Following up to check whether you got a chance to review the suggestion given.If it helps,consider accepting it as solution,so that it will be helpful for other members of the community who have similar problems as yours to solve it faster. Glad to help.
Thank you.