powerbi-consumption-cli

Compare original and translation side by side

🇺🇸

Original

English

🇨🇳

Translation

Chinese

Update Check — ONCE PER SESSION (mandatory) The first time this skill is used in a session, run the check-updates skill before proceeding.
GitHub Copilot CLI / VS Code: invoke the
check-updates
skill.
Claude Code / Cowork / Cursor / Windsurf / Codex: compare local vs remote package.json version.

Skip if the check was already performed earlier in this session.

CRITICAL NOTES

To find the workspace details (including its ID) from workspace name: list all workspaces and, then, use JMESPath filtering

To find the item details (including its ID) from workspace ID, item type, and item name: list all items of that type in that workspace and, then, use JMESPath filtering

更新检查 — 每个会话仅需一次（必填） 在会话中首次使用此技能前，请先运行check-updates技能。
GitHub Copilot CLI / VS Code：调用
check-updates
技能。
Claude Code / Cowork / Cursor / Windsurf / Codex：比较本地与远程package.json版本。

若本次会话中已执行过检查，则可跳过。

重要说明

要从工作区名称获取工作区详情（包括其ID）：列出所有工作区，然后使用JMESPath过滤

要从工作区ID、项类型和项名称获取项详情（包括其ID）：列出该工作区中所有对应类型的项，然后使用JMESPath过滤

Power BI Semantic Model Consumption — CLI Skill

Power BI Semantic Model 消费 — CLI技能

Task	Reference	Notes
Finding Workspaces and Items in Fabric	COMMON-CLI.md § Finding Workspaces and Items in Fabric	Mandatory — READ link first [needed for finding workspace id by its name or item id by its name, item type, and workspace id]
Fabric Topology & Key Concepts	COMMON-CORE.md § Fabric Topology & Key Concepts	Hierarchy; Finding Things in Fabric
Environment URLs	COMMON-CORE.md § Environment URLs	Production (Public Cloud)
Authentication & Token Acquisition	COMMON-CORE.md § Authentication & Token Acquisition	Wrong audience = 401; covers token audiences, delegated vs app permissions, OAuth flows, identity types, and Entra app registration
Core Control-Plane REST APIs	COMMON-CORE.md § Core Control-Plane REST APIs	Includes workspace/item CRUD, resolve-by-name, pagination, LRO polling, and rate-limiting patterns
OneLake Data Access	COMMON-CORE.md § OneLake Data Access	Requires `storage.azure.com` token, not Fabric token; covers URL structure, ADLS Gen2 parity, and shortcuts
Job Execution	COMMON-CORE.md § Job Execution	Run On-Demand Job; Get / Cancel Job
Capacity Management	COMMON-CORE.md § Capacity Management	List Capacities; Assign Workspace to Capacity
Gotchas, Best Practices & Troubleshooting	COMMON-CORE.md § Gotchas, Best Practices & Troubleshooting	Common Errors; Best Practices
Tool Selection Rationale	COMMON-CLI.md § Tool Selection Rationale
Authentication Recipes	COMMON-CLI.md § Authentication Recipes	`az login` flows, environment detection, token acquisition, and debugging
Fabric Control-Plane API via `az rest`	COMMON-CLI.md § Fabric Control-Plane API via `az rest`	Always pass `--resource` ; includes workspace/item operations, pagination, and LRO patterns
OneLake Data Access via `curl`	COMMON-CLI.md § OneLake Data Access via `curl`	Use `curl` not `az rest` (different token audience); file list/read/upload/delete and directory creation
SQL / TDS Data-Plane Access	COMMON-CLI.md § SQL / TDS Data-Plane Access	`sqlcmd` (Go) connect, query, CSV export, service principal auth, and connection parameter discovery
Job Execution (CLI)	COMMON-CLI.md § Job Execution	Run notebooks/pipelines, refresh semantic models, check/cancel jobs
OneLake Shortcuts	COMMON-CLI.md § OneLake Shortcuts	Create a Shortcut; List Shortcuts; Delete a Shortcut
Capacity Management (CLI)	COMMON-CLI.md § Capacity Management	List Capacities; Assign Workspace to Capacity
Composite Recipes	COMMON-CLI.md § Composite Recipes	End-to-end workspace→lakehouse→file, SQL endpoint→query, and notebook execution recipes
Gotchas & Troubleshooting (CLI-Specific)	COMMON-CLI.md § Gotchas & Troubleshooting (CLI-Specific)
Quick Reference	COMMON-CLI.md § Quick Reference	`az rest` Template; Token Audience ↔ CLI Tool Matrix
Prerequisites	SKILL.md § Prerequisites
Must/Prefer/Avoid	SKILL.md § Must/Prefer/Avoid	Guardrails for read-only semantic model usage. MUST DO; PREFER; AVOID
Metadata Discovery	SKILL.md § Metadata Discovery	INFO.VIEW.* and INFO.* functions.
Recommended Discovery Order	SKILL.md § Recommended Discovery Order	Preferred order for metadata exploration
Frequently Used INFO Functions	SKILL.md § Frequently Used INFO Functions	High-usage function list for first-pass discovery
Complete INFO Function Catalog (Dynamic)	discovery-queries.md § Complete INFO Function Catalog (Dynamic)
Metadata Object → INFO Function Map	SKILL.md § Metadata Object → INFO Function Map	Inlined mapping for object-focused discovery
Query Execution	SKILL.md § Query Execution	ExecuteQuery usage shape
Troubleshooting	SKILL.md § Troubleshooting	Resolve common execution and metadata issues
Examples	SKILL.md § Examples	Sample Metadata Query; Sample Data Query
Scope Estimation Queries	discovery-queries.md § Scope Estimation Queries
INFO Output Columns	discovery-queries.md § INFO Output Columns	INFO.VIEW.* (preferred first-pass metadata); Critical INFO.* (deep metadata / diagnostics)
Narrowing Results (Projection + Filtering)	discovery-queries.md § Narrowing Results (Projection + Filtering)
Deep Metadata Queries	discovery-queries.md § Deep Metadata Queries
Dependency Discovery	discovery-queries.md § Dependency Discovery	Dependency rowset for a DAX query; Dependency rows scoped to a measure; Reverse dependencies (what references a measure)

任务	参考链接	说明
在Fabric中查找工作区和项	COMMON-CLI.md § 在Fabric中查找工作区和项	必填 — 先阅读链接内容[需要通过名称查找工作区ID，或通过名称、项类型和工作区ID查找项ID]
Fabric拓扑与核心概念	COMMON-CORE.md § Fabric拓扑与核心概念	层级结构；在Fabric中查找资源
环境URL	COMMON-CORE.md § 环境URL	生产环境（公有云）
身份验证与令牌获取	COMMON-CORE.md § 身份验证与令牌获取	受众错误会导致401；涵盖令牌受众、委托权限与应用权限、OAuth流程、身份类型以及Entra应用注册
核心控制平面REST API	COMMON-CORE.md § 核心控制平面REST API	包含工作区/项的CRUD操作、按名称解析、分页、LRO轮询以及速率限制模式
OneLake数据访问	COMMON-CORE.md § OneLake数据访问	需要 `storage.azure.com` 令牌，而非Fabric令牌；涵盖URL结构、ADLS Gen2兼容性以及快捷方式
作业执行	COMMON-CORE.md § 作业执行	运行按需作业；获取/取消作业
容量管理	COMMON-CORE.md § 容量管理	列出容量；为工作区分配容量
常见问题、最佳实践与故障排除	COMMON-CORE.md § 常见问题、最佳实践与故障排除	常见错误；最佳实践
工具选择依据	COMMON-CLI.md § 工具选择依据
身份验证方案	COMMON-CLI.md § 身份验证方案	`az login` 流程、环境检测、令牌获取以及调试
通过 `az rest` 调用Fabric控制平面API	COMMON-CLI.md § 通过 `az rest` 调用Fabric控制平面API	务必传递 `--resource` 参数；包含工作区/项操作、分页以及LRO模式
通过 `curl` 访问OneLake数据	COMMON-CLI.md § 通过 `curl` 访问OneLake数据	使用 `curl` 而非 `az rest` （令牌受众不同）；文件列出/读取/上传/删除以及目录创建
SQL / TDS数据平面访问	COMMON-CLI.md § SQL / TDS数据平面访问	`sqlcmd` （Go版本）连接、查询、CSV导出、服务主体身份验证以及连接参数发现
作业执行（CLI）	COMMON-CLI.md § 作业执行	运行笔记本/管道、刷新语义模型、检查/取消作业
OneLake快捷方式	COMMON-CLI.md § OneLake快捷方式	创建快捷方式；列出快捷方式；删除快捷方式
容量管理（CLI）	COMMON-CLI.md § 容量管理	列出容量；为工作区分配容量
复合方案	COMMON-CLI.md § 复合方案	端到端的工作区→湖仓→文件、SQL端点→查询以及笔记本执行方案
常见问题与故障排除（CLI专属）	COMMON-CLI.md § 常见问题与故障排除（CLI专属）
快速参考	COMMON-CLI.md § 快速参考	`az rest` 模板；令牌受众 ↔ CLI工具矩阵
先决条件	SKILL.md § 先决条件
必须/推荐/避免	SKILL.md § 必须/推荐/避免	只读语义模型使用的约束规则。必须执行；推荐执行；避免执行
元数据发现	SKILL.md § 元数据发现	INFO.VIEW.* 和 INFO.* 函数。
推荐的发现顺序	SKILL.md § 推荐的发现顺序	元数据探索的首选顺序
常用INFO函数	SKILL.md § 常用INFO函数	首次发现时常用的函数列表
完整INFO函数目录（动态）	discovery-queries.md § 完整INFO函数目录（动态）
元数据对象 → INFO函数映射	SKILL.md § 元数据对象 → INFO函数映射	面向对象发现的内联映射
查询执行	SKILL.md § 查询执行	ExecuteQuery的使用方式
故障排除	SKILL.md § 故障排除	解决常见的执行和元数据问题
示例	SKILL.md § 示例	元数据查询示例；数据查询示例
范围估算查询	discovery-queries.md § 范围估算查询
INFO输出列	discovery-queries.md § INFO输出列	INFO.VIEW.（首选的首次元数据查询）；关键INFO.（深度元数据/诊断）
缩小结果范围（投影+过滤）	discovery-queries.md § 缩小结果范围（投影+过滤）
深度元数据查询	discovery-queries.md § 深度元数据查询
依赖关系发现	discovery-queries.md § 依赖关系发现	DAX查询的依赖关系行集；度量值的依赖关系行；反向依赖（哪些对象引用了该度量值）

Prerequisites

先决条件

COMMON-CORE.md — Fabric concepts, authentication, and control-plane API context.
COMMON-CLI.md — CLI-oriented discovery and token/audience patterns.

COMMON-CORE.md — Fabric概念、身份验证以及控制平面API上下文。
COMMON-CLI.md — 面向CLI的资源发现以及令牌/受众模式。

Must/Prefer/Avoid

必须/推荐/避免

MUST DO

必须执行

Keep this skill read-only: metadata discovery and analytical DAX queries only.
Treat DAX data queries and
```
INFO.VIEW.*
```
as available to any user with read access to the semantic model; assume other
```
INFO.*
```
functions may require elevated permissions.
Resolve workspace and semantic model item identity dynamically; do not hardcode IDs.
Use DAX
```
INFO.VIEW.*
```
/
```
INFO.*
```
for metadata discovery before writing data queries.

保持此技能为只读模式：仅用于元数据发现和分析性DAX查询。
假设拥有语义模型只读权限的用户均可使用DAX数据查询和
```
INFO.VIEW.*
```
函数；其他
```
INFO.*
```
函数可能需要更高权限。
动态解析工作区和语义模型项的标识；不要硬编码ID。
在编写数据查询前，使用DAX
```
INFO.VIEW.*
```
/
```
INFO.*
```
进行元数据发现。

PREFER

AVOID

避免执行

Model-change operations in this skill.

在本技能中执行模型修改操作。

Recommended Discovery Order

Frequently Used INFO Functions

常用INFO函数

```
INFO.VIEW.TABLES
```
```
INFO.VIEW.MEASURES
```
```
INFO.VIEW.COLUMNS
```
```
INFO.VIEW.RELATIONSHIPS
```
```
INFO.PARTITIONS
```
```
INFO.MODEL
```
```
INFO.STORAGETABLECOLUMNSEGMENTS
```
```
INFO.DEPENDENCIES
```
```
INFO.EXPRESSIONS
```
```
INFO.ROLES
```
```
INFO.STORAGETABLECOLUMNS
```
```
INFO.CALCULATIONGROUPS
```
```
INFO.CALCULATIONITEMS
```
```
INFO.CULTURES
```
```
INFO.OBJECTTRANSLATIONS
```
```
INFO.USERDEFINEDFUNCTIONS
```
```
INFO.REFRESHPOLICIES
```
```
INFO.ATTRIBUTEHIERARCHYSTORAGES
```
```
INFO.COLUMNPARTITIONSTORAGES
```
```
INFO.COLUMNSTORAGES
```
```
INFO.DICTIONARYSTORAGES
```
```
INFO.HIERARCHYSTORAGES
```
```
INFO.PARTITIONSTORAGES
```
```
INFO.RELATIONSHIPINDEXSTORAGES
```
```
INFO.RELATIONSHIPSTORAGES
```
```
INFO.SEGMENTMAPSTORAGES
```
```
INFO.SEGMENTSTORAGES
```
```
INFO.STORAGEFOLDERS
```
```
INFO.STORAGEFILES
```
```
INFO.TABLESTORAGES
```

INFO.GENERALSEGMENTMAPSEGMENTMETADATASTORAGES

```
INFO.DELTATABLEMETADATASTORAGES
```
```
INFO.PARQUETFILESTORAGES
```
```
INFO.STORAGETABLES
```

```
INFO.VIEW.TABLES
```
```
INFO.VIEW.MEASURES
```
```
INFO.VIEW.COLUMNS
```
```
INFO.VIEW.RELATIONSHIPS
```
```
INFO.PARTITIONS
```
```
INFO.MODEL
```
```
INFO.STORAGETABLECOLUMNSEGMENTS
```
```
INFO.DEPENDENCIES
```
```
INFO.EXPRESSIONS
```
```
INFO.ROLES
```
```
INFO.STORAGETABLECOLUMNS
```
```
INFO.CALCULATIONGROUPS
```
```
INFO.CALCULATIONITEMS
```
```
INFO.CULTURES
```
```
INFO.OBJECTTRANSLATIONS
```
```
INFO.USERDEFINEDFUNCTIONS
```
```
INFO.REFRESHPOLICIES
```
```
INFO.ATTRIBUTEHIERARCHYSTORAGES
```
```
INFO.COLUMNPARTITIONSTORAGES
```
```
INFO.COLUMNSTORAGES
```
```
INFO.DICTIONARYSTORAGES
```
```
INFO.HIERARCHYSTORAGES
```
```
INFO.PARTITIONSTORAGES
```
```
INFO.RELATIONSHIPINDEXSTORAGES
```
```
INFO.RELATIONSHIPSTORAGES
```
```
INFO.SEGMENTMAPSTORAGES
```
```
INFO.SEGMENTSTORAGES
```
```
INFO.STORAGEFOLDERS
```
```
INFO.STORAGEFILES
```
```
INFO.TABLESTORAGES
```

INFO.GENERALSEGMENTMAPSEGMENTMETADATASTORAGES

```
INFO.DELTATABLEMETADATASTORAGES
```
```
INFO.PARQUETFILESTORAGES
```
```
INFO.STORAGETABLES
```

Metadata Object → INFO Function Map

元数据对象 → INFO函数映射

Metadata Object	Primary INFO functions
Model	`INFO.MODEL`
Tables	`INFO.VIEW.TABLES`
Columns	`INFO.VIEW.COLUMNS` , `INFO.GROUPBYCOLUMNS` , `INFO.RELATEDCOLUMNDETAILS`
Measures	`INFO.VIEW.MEASURES` , `INFO.FORMATSTRINGDEFINITIONS` , `INFO.DETAILROWSDEFINITIONS`
Relationships	`INFO.VIEW.RELATIONSHIPS`
Partitions	`INFO.PARTITIONS` , `INFO.EXPRESSIONS` , `INFO.QUERYGROUPS` , `INFO.REFRESHPOLICIES` , `INFO.DATACOVERAGEDEFINITIONS`
Security roles & permissions	`INFO.ROLES` , `INFO.TABLEPERMISSIONS` , `INFO.COLUMNPERMISSIONS`
Hierarchies	`INFO.HIERARCHIES` , `INFO.LEVELS` , `INFO.ATTRIBUTEHIERARCHIES` , `INFO.VARIATIONS`
Calculation groups/items	`INFO.CALCULATIONGROUPS` , `INFO.CALCULATIONITEMS` , `INFO.CALCULATIONEXPRESSIONS`
Perspectives	`INFO.PERSPECTIVES` , `INFO.PERSPECTIVETABLES` , `INFO.PERSPECTIVECOLUMNS` , `INFO.PERSPECTIVEHIERARCHIES` , `INFO.PERSPECTIVEMEASURES`
Calendars	`INFO.CALENDARS` , `INFO.CALENDARCOLUMNGROUPS` , `INFO.CALENDARCOLUMNREFERENCES`
Cultures	`INFO.CULTURES`
Object translations	`INFO.OBJECTTRANSLATIONS`
Functions	`INFO.USERDEFINEDFUNCTIONS`
Dependencies / lineage	`INFO.DEPENDENCIES` , `INFO.CHANGEDPROPERTIES` , `INFO.EXCLUDEDARTIFACTS`
Storage internals / size	`INFO.STORAGEFOLDERS` , `INFO.STORAGEFILES` , `INFO.TABLESTORAGES` , `INFO.COLUMNSTORAGES` , `INFO.PARTITIONSTORAGES` , `INFO.SEGMENTMAPSTORAGES` , `INFO.DICTIONARYSTORAGES` , `INFO.COLUMNPARTITIONSTORAGES` , `INFO.SEGMENTSTORAGES` , `INFO.RELATIONSHIPSTORAGES` , `INFO.RELATIONSHIPINDEXSTORAGES` , `INFO.ATTRIBUTEHIERARCHYSTORAGES` , `INFO.HIERARCHYSTORAGES` , `INFO.GENERALSEGMENTMAPSEGMENTMETADATASTORAGES` , `INFO.DELTATABLEMETADATASTORAGES` , `INFO.PARQUETFILESTORAGES` , `INFO.STORAGETABLES` , `INFO.STORAGETABLECOLUMNS` , `INFO.STORAGETABLECOLUMNSEGMENTS`

元数据对象	主要INFO函数
Model	`INFO.MODEL`
Tables	`INFO.VIEW.TABLES`
Columns	`INFO.VIEW.COLUMNS` , `INFO.GROUPBYCOLUMNS` , `INFO.RELATEDCOLUMNDETAILS`
Measures	`INFO.VIEW.MEASURES` , `INFO.FORMATSTRINGDEFINITIONS` , `INFO.DETAILROWSDEFINITIONS`
Relationships	`INFO.VIEW.RELATIONSHIPS`
Partitions	`INFO.PARTITIONS` , `INFO.EXPRESSIONS` , `INFO.QUERYGROUPS` , `INFO.REFRESHPOLICIES` , `INFO.DATACOVERAGEDEFINITIONS`
安全角色与权限	`INFO.ROLES` , `INFO.TABLEPERMISSIONS` , `INFO.COLUMNPERMISSIONS`
Hierarchies	`INFO.HIERARCHIES` , `INFO.LEVELS` , `INFO.ATTRIBUTEHIERARCHIES` , `INFO.VARIATIONS`
Calculation groups/items	`INFO.CALCULATIONGROUPS` , `INFO.CALCULATIONITEMS` , `INFO.CALCULATIONEXPRESSIONS`
Perspectives	`INFO.PERSPECTIVES` , `INFO.PERSPECTIVETABLES` , `INFO.PERSPECTIVECOLUMNS` , `INFO.PERSPECTIVEHIERARCHIES` , `INFO.PERSPECTIVEMEASURES`
Calendars	`INFO.CALENDARS` , `INFO.CALENDARCOLUMNGROUPS` , `INFO.CALENDARCOLUMNREFERENCES`
Cultures	`INFO.CULTURES`
Object translations	`INFO.OBJECTTRANSLATIONS`
Functions	`INFO.USERDEFINEDFUNCTIONS`
依赖关系/血缘	`INFO.DEPENDENCIES` , `INFO.CHANGEDPROPERTIES` , `INFO.EXCLUDEDARTIFACTS`
存储内部/大小	`INFO.STORAGEFOLDERS` , `INFO.STORAGEFILES` , `INFO.TABLESTORAGES` , `INFO.COLUMNSTORAGES` , `INFO.PARTITIONSTORAGES` , `INFO.SEGMENTMAPSTORAGES` , `INFO.DICTIONARYSTORAGES` , `INFO.COLUMNPARTITIONSTORAGES` , `INFO.SEGMENTSTORAGES` , `INFO.RELATIONSHIPSTORAGES` , `INFO.RELATIONSHIPINDEXSTORAGES` , `INFO.ATTRIBUTEHIERARCHYSTORAGES` , `INFO.HIERARCHYSTORAGES` , `INFO.GENERALSEGMENTMAPSEGMENTMETADATASTORAGES` , `INFO.DELTATABLEMETADATASTORAGES` , `INFO.PARQUETFILESTORAGES` , `INFO.STORAGETABLES` , `INFO.STORAGETABLECOLUMNS` , `INFO.STORAGETABLECOLUMNSEGMENTS`

Query Execution

查询执行

Use a single

ExecuteQuery

capability with payload concepts:

```
artifactId
```
: target semantic model identifier.
```
daxQuery
```
: direct DAX query text.

Temporary implementation note: current query integration is expected to be replaced before release by a public HTTP endpoint exposing
ExecuteQuery
.

使用单一的

ExecuteQuery

功能，包含以下负载概念：

```
artifactId
```
: 目标语义模型标识符。
```
daxQuery
```
: 直接的DAX查询文本。

临时实现说明：当前的查询集成预计在发布前会被公开HTTP端点替代，该端点将暴露
ExecuteQuery
功能。

Troubleshooting

故障排除

ExecuteQuery capability is unavailable in the MCP server
- Issue: Query execution cannot start because
```
ExecuteQuery
```
  is not available in the active tool list.
- Cause: The Fabric MCP server is not registered, not loaded, or the current client session has stale tool metadata.
- Fix: Verify the active MCP server/tool inventory and confirm
```
ExecuteQuery
```
  is exposed.
Advanced INFO functions return permission errors
- Issue: Queries against
```
INFO.*
```
  fail with authorization or privilege-related errors.
- Cause: Many
```
INFO.*
```
  functions require elevated semantic model permissions beyond standard read access.
- Fix: Start with
```
INFO.VIEW.*
```
  functions for read-oriented discovery.
Metadata output volume is too large for focused analysis
- Issue: Returning full metadata rowsets introduces too many properties and crowds the working context.
- Cause: Unbounded
```
INFO.VIEW.*
```
  and
```
INFO.*
```
  queries return broad object/property surfaces that are often unnecessary for the current task.
- Fix: Use the scope estimation queries in discovery-queries.md § Scope Estimation Queries to estimate scope and inspect output schemas, then narrow results with projection and filtering as shown in discovery-queries.md § Narrowing Results (Projection + Filtering).
Do not use
INFO
DAX functions to retrieve role memberships
- Issue:
```
INFO.ROLEMEMBERSHIPS()
```
  returns empty or incomplete results.
- Cause: Role members are assigned at the service level (Entra ID) after deployment, not in the model definition — so DAX
```
INFO
```
  functions cannot reliably surface them.
- Fix: Use the Power BI REST API instead. See powerbi-authoring-cli § Security Role Memberships.

ExecuteQuery功能在MCP服务器中不可用
- 问题： 由于
```
ExecuteQuery
```
  不在活动工具列表中，查询无法启动。
- 原因： Fabric MCP服务器未注册、未加载，或当前客户端会话的工具元数据已过期。
- 解决方法： 验证活动MCP服务器/工具清单，确认
```
ExecuteQuery
```
  已暴露。
高级INFO函数返回权限错误
- 问题： 针对
```
INFO.*
```
  的查询因授权或权限相关错误失败。
- 原因： 许多
```
INFO.*
```
  函数需要超出标准只读权限的更高语义模型权限。
- 解决方法： 从
```
INFO.VIEW.*
```
  函数开始进行面向只读的发现。
元数据输出量过大，不利于聚焦分析
- 问题： 返回完整的元数据行集会引入过多属性，占用工作上下文。
- 原因： 无限制的
```
INFO.VIEW.*
```
  和
```
INFO.*
```
  查询会返回广泛的对象/属性信息，而这些信息通常与当前任务无关。
- 解决方法： 使用discovery-queries.md § 范围估算查询中的范围估算查询来估算范围并检查输出架构，然后通过投影和过滤缩小结果范围，具体请参阅discovery-queries.md § 缩小结果范围（投影+过滤）。
不要使用
INFO
DAX函数检索角色成员
- 问题：
```
INFO.ROLEMEMBERSHIPS()
```
  返回空或不完整的结果。
- 原因： 角色成员是在部署后在服务级别（Entra ID）分配的，而非在模型定义中，因此DAX
```
INFO
```
  函数无法可靠地获取这些信息。
- 解决方法： 改用Power BI REST API。请参阅powerbi-authoring-cli § 安全角色成员。

Examples

示例

For the full query catalog (including dependency patterns), see discovery-queries.md.

如需完整的查询目录（包括依赖关系模式），请参阅discovery-queries.md。

Sample Metadata Query

元数据查询示例

dax

EVALUATE
INFO.VIEW.TABLES()
ORDER BY [Name]

dax

EVALUATE
INFO.VIEW.TABLES()
ORDER BY [Name]

Sample Data Query

数据查询示例

dax

DEFINE
MEASURE 'Sales'[Total Sales] = SUM('Sales'[Amount])
EVALUATE
SUMMARIZECOLUMNS(
    'Customer'[Customer Name],
    "Total Sales", [Total Sales]
)
ORDER BY [Total Sales] DESC

dax

DEFINE
MEASURE 'Sales'[Total Sales] = SUM('Sales'[Amount])
EVALUATE
SUMMARIZECOLUMNS(
    'Customer'[Customer Name],
    "Total Sales", [Total Sales]
)
ORDER BY [Total Sales] DESC