CtrlK
BlogDocsLog inGet started
Tessl Logo
SkillPublic

powerbi-airflow-to-orchestra

Use this skill when the user wants to convert an Airflow task that uses PowerBIDatasetRefreshOperator (apache-airflow-providers-microsoft-azure, module airflow.providers.microsoft.azure.operators.powerbi) into an equivalent Orchestra pipeline task targeting Power BI. Triggers: any mention of migrating or rewriting Power BI Airflow tasks to Orchestra; Airflow DAG code containing PowerBIDatasetRefreshOperator, PowerBIHook, conn_id="powerbi_default", or dataset_id/group_id refresh parameters. Must be read before finalizing any Orchestra YAML that contains integration: POWER_BI.

Quality

86%

Does it follow best practices?

Run evals on this skill

Adds up to 20 points to the overall score

View guide
SecuritybySnyk

Passed

No findings from the security scan

SKILL.md
Quality
Evals
Security

Quality

Content

82%Weight 40%Scale 1-5

Reviews the quality of instructions and guidance provided to agents. Good implementation is clear, handles edge cases, and produces reliable results.

A high-quality conversion skill body: it leads with a precise parameter mapping and complete YAML templates, walks a real before/after example with justified inputs-vs-literal decisions, and closes with an unusually sharp Gotchas list that anticipates real failure modes (fabricated ENV references, workspace_id over-plumbing, dataset/dataflow field mixing). The main improvements are tightening the repeated workspace_id guidance and making final-YAML validation an explicit step rather than an implied one.

DimensionReasoningScore

Conciseness

Nearly every section carries non-obvious, Orchestra-specific knowledge Claude cannot be assumed to know (the group_id→workspace_id rename, the additionalProperties: false constraint, the exact refresh_type enum). Minor trimming opportunities keep it at anchor 4 rather than 5: the dense six-line reasoning paragraph before the "after" YAML, and the leave-workspace_id-null guidance repeated across the mapping table, the YAML comments, and a Gotchas bullet.

4 / 5

Actionability

The body is fully executable: copy-paste-ready YAML blocks for both POWER_BI_REFRESH_DATASET and POWER_BI_REFRESH_DATAFLOW, a parameter-by-parameter mapping table, a complete before/after example with inputs: wiring, and exact enum lists. It matches anchor 5 — the examples cover the common cases end-to-end.

5 / 5

Workflow Clarity

The five Conversion Steps are clearly sequenced (identify operator → create/verify connection → replace with task block → check for hand-rolled dataflow calls → wire dependencies) and the Gotchas section functions as a pitfall checklist. It falls short of anchor 5 because validation is implicit rather than an explicit loop — there is no final step like "verify the produced YAML against the parameter model" even though additionalProperties: false is the first gotcha — so anchor 4's "minor validation gaps" fits.

4 / 5

Progressive Disclosure

No bundle files exist (references/, scripts/, assets/ are absent), and the single-file body is cleanly sectioned with one-level-deep, clearly signaled references: four external doc URLs plus named sibling skills (airflow-connections-to-orchestra, slack-airflow-to-orchestra). Anchor 4 fits: good structure with minor gaps — the ~60-line before/after example and the Adding Alerts section are inline content that could arguably live in separate reference files.

4 / 5

Total

17

/

20

Passed

Description

82%Weight 40%Scale 1-5

Based on the skill's description, can an agent find and select it at the right time? Clear, specific descriptions lead to better discovery.

A strong description: it states one concrete conversion capability with exact module and operator names, gives an explicit multi-class trigger list covering both source-DAG tokens and output YAML tokens, and defines when it must be read. Its only real weakness is incomplete capability coverage — the dataflow conversion path and alerts guidance in the body are invisible from the description alone.

DimensionReasoningScore

Specificity

The description names one concrete, well-qualified action — "convert an Airflow task that uses PowerBIDatasetRefreshOperator ... into an equivalent Orchestra pipeline task targeting Power BI" — with the full module path. It stays at anchor 3 rather than 4 because it lists only that single conversion action with coverage gaps: the dataflow-refresh conversion and the alerts handling that the skill also covers are never mentioned.

3 / 5

Completeness

Both what and when are explicitly and concretely answered: "Use this skill when the user wants to convert ..." states the what, an explicit "Triggers:" list gives concrete trigger phrases, and "Must be read before finalizing any Orchestra YAML that contains integration: POWER_BI" adds a proactive trigger. This matches the anchor-5 example structure exactly.

5 / 5

Trigger Term Quality

Triggers span natural language ("any mention of migrating or rewriting Power BI Airflow tasks to Orchestra"), code-level tokens ("PowerBIDatasetRefreshOperator, PowerBIHook, conn_id=\"powerbi_default\", or dataset_id/group_id refresh parameters"), and the output side ("integration: POWER_BI"). This is good, multi-angle keyword coverage but a few natural terms are missing — dataflow, semantic model — so it fits anchor 4 rather than the comprehensive anchor 5.

4 / 5

Distinctiveness Conflict Risk

The skill occupies a clear niche (Power BI Airflow-to-Orchestra conversion) with highly distinct trigger tokens — the operator class name, the provider module, the powerbi_default conn_id, and the POWER_BI integration constant — that no sibling conversion skill (slack, azure-connections) would claim. Minimal conflict risk, matching anchor 5.

5 / 5

Total

17

/

20

Passed

Validation

100%

Checks the skill against the spec for correct structure and formatting. All validation checks must pass before discovery and implementation can be scored.

Validation — 16 / 16 Passed

Validation for skill structure

No warnings or errors.

Repository

orchestra-hq/orchestra-skills

Path

skills/migrate-to-orchestra/skills/powerbi-airflow-to-orchestra/SKILL.md

Reviewed

Table of Contents

Is this your skill?

If you maintain this skill, you can claim it as your own. Once claimed, you can manage eval scenarios, bundle related skills, attach documentation or rules, and ensure cross-agent compatibility.