# Powerbi Query Design

> Translate business questions into Power BI-ready source extraction plans, Power Query steps, SQL/OData/API queries, semantic model requirements, DAX definitions, validation checks, and report requirements for any supported Power BI data source.

- Skill: `rweisssieker-xp/powerbi-query-design` (Agent Skill, multi-file: 5 files)
- Install (CLI): `npx skillmds@latest add rweisssieker-xp/powerbi-query-design`
- Raw SKILL.md: https://api.skillmd.com/api/skills/rweisssieker-xp/powerbi-query-design/raw
- Safety review: pending
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Data & Analytics
- Author: rweisssieker-xp (https://skillmd.com/u/rweisssieker-xp)
- Updated: 2026-09-17
- Page: https://skillmd.com/skills/rweisssieker-xp/powerbi-query-design

---


# Power BI Query Design

Use this skill to turn a reporting question into an implementable source-to-model specification.

## Workflow

1. Restate the business question as facts, dimensions, filters, date logic, grain, and decision action.
2. Identify source path: file/folder, SQL/database, data warehouse, Fabric lakehouse, SAP, SaaS connector, OData, REST API, GraphQL/custom connector, streaming, or manual input.
3. Draft source artifacts: entity/table, filters, joins, pagination, incremental boundaries, selected fields, and privacy constraints.
4. Define Power BI model impact: fact table, dimensions, relationships, DAX measures, RLS, refresh, validation.
5. Include reconciliation checks against trusted source totals or extracts.
6. Flag source-specific assumptions: field names, status values, fiscal calendars, currency, PII, security, and latency.

## References

- Load `references/query-to-powerbi.md` for translation patterns and output structure.
- Load `references/business-question-examples.md` for common business problem examples.

## Assets

- `assets/query-powerbi-spec-template.md`: implementation spec template.

## Scripts

- `scripts/new_query_powerbi_spec.py`: Generate a starter spec from a business question.