適用於：
匯出數據行 匯出數據表 量值 視覺計算 
DAX 查詢
傳回具有語意模型中每個批注相關信息的數據表。 此資訊可協助您瞭解模型。
語法
INFO.ANNOTATIONS ( [<Restriction name>, <Restriction value>], ... )
參數
這個 DAX 函式的參數是選擇性的。 使用參數時，必須指定兩者。 允許一組以上的參數。 限制名稱和值是文字，並以雙引號輸入。
| 術語 | 定義 |
|---|---|
| 限制名稱 | 用來篩選結果的限制名稱。 |
| 限制值 | 用來篩選限制結果的值。 |
限制
一般而言，DAX 函式結果的所有數據行都可以用來做為限制。 也可能允許其他限制。
傳回值
具有下列資料行的數據表：
| 列 | 描述 |
|---|---|
| [ID] | 對象的參考。 標識元通常會自動產生，而且不應該在建立模型之後變更。 數據類型為不帶正負號的long（4個字節）。 |
| [ObjectID] | 擁有這個註釋之 對象的參考。 |
| [ObjectType] | 擁有這個註釋之物件的型別參考。 |
| [名稱] | 用於程式代碼、文稿和查詢的物件名稱。 |
| [值] | 批注的值。 |
| [ModifiedTime] | 上次修改對象的時間。 |
言論
只有在語意模型上擁有寫入權限的使用者才能執行，且無法在 Power BI Desktop 中與語意模型連線時執行。 此函式可用於 DAX 查詢，而且無法在計算中使用。
範例 1 - DAX 查詢
下列 DAX 查詢可以在查詢檢視 DAX中執行：
EVALUATE
INFO.ANNOTATIONS()
此 DAX 查詢會傳回具有此 DAX 函式所有數據行的數據表。
範例 2 - 使用聯結 DAX 查詢
下列 DAX 查詢可以在查詢檢視 DAX中執行：
EVALUATE
VAR _ObjectTypeEnum =
DATATABLE(
"ObjectType",INTEGER,
"Object",STRING,
{
{0,"Null"},
{1,"Model"},
{2,"DataSource"},
{3,"Table"},
{4,"Column"},
{5,"AttributeHierarchy"},
{6,"Partition"},
{7,"Relationship"},
{8,"Measure"},
{9,"Hierarchy"},
{10,"Level"},
{11,"Annotation"},
{12,"KPI"},
{13,"Culture"},
{14,"ObjectTranslation"},
{15,"LinguisticMetadata"},
{29,"Perspective"},
{30,"PerspectiveTable"},
{31,"PerspectiveColumn"},
{32,"PerspectiveHierarchy"},
{33,"PerspectiveMeasure"},
{34,"Role"},
{35,"RoleMembership"},
{36,"TablePermission"},
{37,"Variation"},
{38,"Set"},
{39,"PerspectiveSet"},
{40,"ExtendedProperty"},
{41,"Expression"},
{42,"ColumnPermission"},
{43,"DetailRowsDefinition"},
{44,"RelatedColumnDetails"},
{45,"GroupByColumn"},
{46,"CalculationGroup"},
{47,"CalculationItem"},
{48,"AlternateOf"},
{49,"RefreshPolicy"},
{50,"FormatStringDefinition"}
}
)
VAR _INFO =
INFO.ANNOTATIONS()
VAR _CombinedTable =
NATURALLEFTOUTERJOIN(
_INFO,
_ObjectTypeEnum
)
VAR _ModelObjects =
UNION(
SELECTCOLUMNS(
INFO.MEASURES(),
"ObjectID", [ID],
"Object Name", [Name]
),
SELECTCOLUMNS(
INFO.TABLES(),
"ObjectID", [ID],
"Object Name", [Name]
),
SELECTCOLUMNS(
INFO.COLUMNS(),
"ObjectID", [ID],
"Object Name", [ExplicitName]
),
SELECTCOLUMNS(
INFO.EXPRESSIONS(),
"ObjectID", [ID],
"Object Name", [Name]
),
SELECTCOLUMNS(
INFO.MODEL(),
"ObjectID", [ID],
"Object Name", [Name]
)
)
VAR _CombinedTable2 =
NATURALLEFTOUTERJOIN(
_CombinedTable,
_ModelObjects
)
RETURN
SELECTCOLUMNS(
_CombinedTable2,
"Object type", [Object],
"Object", [Object Name],
"Annotation name", [Name],
"Annotation value", [Value]
)
ORDER BY [Annotation name]
此 DAX 查詢只會傳回具有指定數據行的數據表，並聯結至其他 INFO DAX 函式和列舉數據表。
枚舉
此 INFO 函式中傳回的數據行會提供列舉或查閱表格的識別碼。 以下是此 DAX 函式中每個列舉的值。
ObjectType
| 數 | 價值 |
|---|---|
| 0 | 零 |
| 1 | 型 |
| 2 | DataSource |
| 3 | 桌子 |
| 4 | 列 |
| 5 | AttributeHierarchy |
| 6 | 分區 |
| 7 | 關係 |
| 8 | 量 |
| 9 | 等級制度 |
| 10 | 水準 |
| 11 | 註解 |
| 12 | KPI |
| 13 | 文化 |
| 14 | ObjectTranslation |
| 15 | LinguisticMetadata |
| 29 | 透視 |
| 30 | PerspectiveTable |
| 31 | PerspectiveColumn |
| 32 | PerspectiveHierarchy |
| 33 | PerspectiveMeasure |
| 34 | 角色 |
| 35 | RoleMembership |
| 36 | TablePermission |
| 37 | 變化 |
| 38 | 設置 |
| 39 | PerspectiveSet |
| 40 | ExtendedProperty |
| 41 | 表達 |
| 42 | ColumnPermission |
| 43 | DetailRowsDefinition |
| 44 | RelatedColumnDetails |
| 45 | GroupByColumn |
| 46 | CalculationGroup |
| 47 | CalculationItem |
| 48 | AlternateOf |
| 49 | RefreshPolicy |
| 50 | FormatStringDefinition |
若要與 INFO 函式聯結，請使用此 DAX 查詢。
EVALUATE
DATATABLE(
"ObjectType",INTEGER,
"Object",STRING,
{
{0,"Null"},
{1,"Model"},
{2,"DataSource"},
{3,"Table"},
{4,"Column"},
{5,"AttributeHierarchy"},
{6,"Partition"},
{7,"Relationship"},
{8,"Measure"},
{9,"Hierarchy"},
{10,"Level"},
{11,"Annotation"},
{12,"KPI"},
{13,"Culture"},
{14,"ObjectTranslation"},
{15,"LinguisticMetadata"},
{29,"Perspective"},
{30,"PerspectiveTable"},
{31,"PerspectiveColumn"},
{32,"PerspectiveHierarchy"},
{33,"PerspectiveMeasure"},
{34,"Role"},
{35,"RoleMembership"},
{36,"TablePermission"},
{37,"Variation"},
{38,"Set"},
{39,"PerspectiveSet"},
{40,"ExtendedProperty"},
{41,"Expression"},
{42,"ColumnPermission"},
{43,"DetailRowsDefinition"},
{44,"RelatedColumnDetails"},
{45,"GroupByColumn"},
{46,"CalculationGroup"},
{47,"CalculationItem"},
{48,"AlternateOf"},
{49,"RefreshPolicy"},
{50,"FormatStringDefinition"}
}
)