# Power BI / Fabric Dataflow Documentation

> **Note:** This documentation is mandatory for all production dataflows
> (Gen1 & Gen2).
> Irrelevant chapters may be left empty but must not be removed.
> Automatically populated fields come from the Power BI / Fabric Service; fields
> marked _"To be completed"_ must be filled in from a business perspective.

---

## 1. Metadata

| Field | Value |
|-----|------|
| Dataflow Name | {{DF_Name}} |
| Description | {{DF_Beschreibung}} |
| Generation | {{DF_Generation}} |
| Dataflow ID | {{DF_ID}} |
| Web URL | {{DF_WebUrl}} |
| Created / configured by | {{DF_ConfiguredBy}} |
| Last modified | {{DF_ModifiedTime}} |
| Business Unit | {{DF_Fachbereich}} |
| Domain | {{DF_Konzerndomaene}} |
| Current Version | 1.0 |
| Status | Production |
| Last Updated | {{DF_ExportDatum}} |

---

## 2. Contacts & Responsibilities

| Role | Name / Team | Contact |
|-----|-------------|--------|
| Business Owner | {{KONTAKT_BusinessOwner}} | {{KONTAKT_BusinessOwnerMail}} |
| Technical Owner | {{KONTAKT_TechOwner}} | {{KONTAKT_TechOwnerMail}} |
| Data Steward | {{KONTAKT_DataSteward}} | {{KONTAKT_DataStewardMail}} |
| Operations / Support | {{KONTAKT_Betrieb}} | {{KONTAKT_BetriebMail}} |

---

## 3. Business Objective & Context

### 3.1 Objective
{{DF_Zielsetzung}}

### 3.2 Business Use Case
{{DF_Anwendungsfall}}

### 3.3 Consumers (Semantic Models / Reports / other Dataflows)
{{DF_Konsumenten}}

---

## 4. Entities & Structure

### 4.1 Entity Overview

{{DF_EntitaetenTabelle}}

### 4.2 Attributes per Entity

{{DF_AttributeTabelle}}

---

## 5. Data Sources & Lineage

### 5.1 Data Source Overview

{{DF_DatenquellenTabelle}}

### 5.2 Detailed Description per Data Source
{{DF_DatenquellenDetail}}

---

## 6. Power Query (Data Transformation)

{{DF_ServiceHinweis}}

### 6.1 Transformation Logic per Entity (M)

{{DF_Queries}}

### 6.2 Full Mashup / M Document

{{DF_MashupDokument}}

### 6.3 Parameters & Functions
{{DF_ParameterHinweis}}

### 6.4 Error Handling & Data Quality

- NULL handling: {{DF_NullHandling}}
- Erroneous rows: {{DF_ErrorHandling}}
- Data validation rules: {{DF_Validierungsregeln}}

### 6.5 Performance Notes

- Query folding active: {{DF_QueryFolding}}
- Known performance bottlenecks: {{DF_PerformanceHinweise}}
- Optimization measures: {{DF_Optimierungen}}

---

## 7. Operations & Maintenance

### 7.1 Refresh

{{DF_RefreshPlan}}

### 7.2 Monitoring & Error Handling
{{DF_Monitoring}}

### 7.3 Known Issues / Technical Debt
{{DF_BekannteProbleme}}

---

## 8. Security & Permissions

### 8.1 Access & Sharing
{{DF_Zugriffe}}

### 8.2 Sensitivity Labels
{{DF_Labels}}

### 8.3 Risks & Limitations
{{DF_Risiken}}

---

## 9. Versioning & Change History

### 9.1 Repository / Storage
{{DF_Repository}}

### 9.2 Change Log

| Version | Date | Change | Type (business/technical) | Author |
|-------|-------|---------|--------------------------|-------|
| 1.0 | {{DF_ExportDatum}} | Automatic initial documentation | technical | Auto-Documentation |

---

## 10. Approval & Review

| Role | Name | Date | Comment |
|-----|------|-------|----------|
| Business | {{REVIEW_FachName}} | {{REVIEW_FachDatum}} | {{REVIEW_FachKommentar}} |
| Technical | {{REVIEW_TechName}} | {{REVIEW_TechDatum}} | {{REVIEW_TechKommentar}} |

---

## 11. Appendices & References
- Parent workspace documentation
- Architecture diagrams
- Regulatory evidence (separate)
