rweisssieker-xp Power BI Query Design
Use this skill to turn a reporting question into an implementable source-to-model specification.
Workflow
- Restate the business question as facts, dimensions, filters, date logic, grain, and decision action.
- Identify source path: file/folder, SQL/database, data warehouse, Fabric lakehouse, SAP, SaaS connector, OData, REST API, GraphQL/custom connector, streaming, or manual input.
- Draft source artifacts: entity/table, filters, joins, pagination, incremental boundaries, selected fields, and privacy constraints.
- Define Power BI model impact: fact table, dimensions, relationships, DAX measures, RLS, refresh, validation.
- Include reconciliation checks against trusted source totals or extracts.
- Flag source-specific assumptions: field names, status values, fiscal calendars, currency, PII, security, and latency.
References
- Load
references/query-to-powerbi.mdfor translation patterns and output structure. - Load
references/business-question-examples.mdfor 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.