通过命令行编写与管理 Fabric Dataflows Gen2,并预览查询后触发刷新。
复制安装指令,让 AI 自动完成配置 · 推荐新手
请帮我安装 askskill 上的 "dataflows-authoring-cli" 技能: 1. 下载 https://raw.githubusercontent.com/microsoft/skills-for-fabric/main/plugins/fabric-authoring/skills/dataflows-authoring-cli/SKILL.md 2. 保存为 ~/.claude/skills/dataflows-authoring-cli/SKILL.md 3. 装好后重载技能,告诉我可以用了
帮我为 Microsoft Fabric 创建一个 Dataflows Gen2:从指定连接读取销售数据,生成 mashup.pq 和 queryMetadata,输出到 Lakehouse,并给出可执行的 CLI 步骤与参数示例。
一套创建数据流的 CLI 命令、所需定义文件示例,以及 Lakehouse 输出配置说明。
我想在保存前迭代调试 Dataflow 的 Power Query M。请使用 executeQuery 与 customMashupDocument 的思路,给我一个预览查询结果的 CLI 操作流程,并说明如何根据预览结果修改 mashup。
一个预览驱动的编写流程,包含查询预览命令、调试步骤和修改 M 脚本的建议。
请帮我更新现有 Fabric Dataflow 的数据源连接,绑定新的 connection,配置输出到 Azure SQL,然后触发一次带参数的 refresh,并列出关键 CLI 命令。
更新数据流连接与目标的命令清单,以及一次参数化刷新的执行示例。
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-updatesskill.- 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
This skill (SKILL.md)
| Section | Notes |
|---|---|
| Tool Stack |
az + jq + base64 + curl |
| Connection | Workspace/dataflow ID discovery |
| Agentic Workflows | Start here. A: create end-to-end; B: modify existing; C: preview loop |
| MUST DO / AVOID / PREFER | Authoring rules |
| Troubleshooting | Symptom → fix table |
| Examples | Runnable bash + PowerShell recipes |
| Output Expectations | Response conventions |
References (in references/)
| File | When to read |
|---|---|
| authoring-cli-quickref.md | One-liner recipes, status enums, base64 helpers, connection-binding quick patterns |
| authoring-script-templates.md | Full bash + PowerShell templates; end-to-end smoke test; LRO polling pattern |
| connection-management.md | List/create/inspect connections; supportedConnectionTypes; resolve ClusterId; ID format cheat sheet |
| mashup-preview.md | executeQuery contract: bootstrap branch, auto-wrap rule, hard avoid for unbounded preview |
| output-destinations.md | Output destination patterns: Lakehouse Table, Lakehouse Files, Warehouse, ADX, Azure SQL. DataDestinations annotation, hidden query, loadEnabled rules, connection limitations |
Common refs (in ../../common/)
| File | When to read |
|---|---|
| COMMON-CLI.md | az login, token acquisition, az rest, pagination, LRO polling, CLI gotchas. § Finding Workspaces and Items in Fabric is mandatory. |
| COMMON-CORE.md | Fabric topology, environment URLs, authentication, core REST API surface |
| ITEM-DEFINITIONS-CORE.md | Definition envelope; per-item-type payload contracts |
| DATAFLOWS-AUTHORING-CORE.md | Authoring capability matrix; 3-part definition structure; M structure; connection model; ALM / Git integration |
Sister skills
| Skill | Use for |
|---|---|
| dataflows-consumption-cli | Execute persisted queries; ad-hoc read-only customMashupDocument with no intent to persist; Arrow → CSV/pandas conversion; refresh status/history. |
| Tool | Role | Install |
|---|---|---|
az CLI | Primary: Auth (az login), REST API calls (az rest), token acquisition. | Pre-installed in most dev environments |
jq | Parse and manipulate JSON responses and definition payloads. | Pre-installed or trivial |
base64 | Encode/decode definition parts for the REST API. | Built into bash / [Convert]::ToBase64String() in PowerShell |
curl | Alternative to az rest when raw HTTP control is needed. | Pre-installed |
…