通过命令行创建、更新并刷新 Fabric Dataflows Gen2 及其连接与输出配置
复制安装指令,让 AI 自动完成配置 · 推荐新手
请帮我安装 askskill 上的 "dataflows-authoring-cli" 技能: 1. 下载 https://raw.githubusercontent.com/microsoft/skills-for-fabric/main/plugins/fabric-skills/skills/dataflows-authoring-cli/SKILL.md 2. 保存为 ~/.claude/skills/dataflows-authoring-cli/SKILL.md 3. 装好后重载技能,告诉我可以用了
请帮我创建一个 Fabric Dataflows Gen2 数据流:从指定数据源读取销售数据,生成 mashup.pq 和 queryMetadata,绑定现有连接,并将输出目标配置为 Lakehouse。最后给出可执行的 CLI 命令和参数说明。
一组用于创建数据流、绑定连接和设置 Lakehouse 输出的 CLI 命令,以及对应配置说明。
我想在保存前预览数据流查询结果。请使用 executeQuery 和 customMashupDocument 的思路,帮我迭代一段 Power Query M:清洗订单表、过滤空值、按月份汇总销售额,并给出预览驱动的修改步骤。
可迭代的 Power Query M 示例、预览执行思路,以及保存前检查和修改步骤。
请为现有 Fabric 数据流生成更新方案:修改输出目标为 Warehouse,补充连接配置,并触发一个带参数的刷新任务。请输出更新、绑定连接和刷新对应的 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 |
…