# Powerbi AI Powerquery Load Contract

> Use when Power Query queries need explicit load contracts for source object keys, columns, types, culture, refresh mode, gateway, privacy, folding, reconciliation, and failure handling.

- Skill: `rweisssieker-xp/powerbi-ai-powerquery-load-contract` (Agent Skill)
- Install (CLI): `npx skillmds@latest add rweisssieker-xp/powerbi-ai-powerquery-load-contract`
- Raw SKILL.md: https://api.skillmd.com/api/skills/rweisssieker-xp/powerbi-ai-powerquery-load-contract/raw
- Safety review: pending
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Coding & Dev Tools
- Author: rweisssieker-xp (https://skillmd.com/u/rweisssieker-xp)
- Updated: 2026-09-17
- Page: https://skillmd.com/skills/rweisssieker-xp/powerbi-ai-powerquery-load-contract

---


# Power BI AI Power Query Load Contract

Use this skill for every production Power Query source.

## Contract Fields

- Source system, connector, object path, object kind, and credential owner.
- Required columns, optional columns, keys, data types, culture, nullability, and uniqueness rules.
- Refresh mode, incremental refresh policy, gateway, privacy level, and folding expectation.
- Row-count, amount-total, min/max date, and checksum-style reconciliation.
- Schema drift behavior and owner routing.

## Output Requirements

- Include a machine-readable load contract and human-readable en-US/de-DE notes.
- Mark hardcoded secrets and personal file paths as blockers.