Regional Vendor Spend Tracker - Semantic Model Documentation

1. Executive Overview & Health Summary

Owner: marcus.lindqvist@northwind-global.example • Upstream Connectors: Excel, File, SQL Server / Azure SQL

Refresh: Failed

2

Tables (2 Import / 0 DQ)

3

Columns (0 Calculated)

1

DAX Measures

1

Relationships (1 Bi-Di)

2

Power Query Steps

1

Bound Reports

Last scheduled refresh failedLast attempt ended 2026-11-11T23:10:00Z. Downstream reports may show stale figures.

Connected to non-production source endpointDetected non-prod identifier in: sql-procurement-dev.northwind.internal.

Reads from local or mapped network driveTables (Dim Vendor) reference a file path that breaks cloud refresh without a personal gateway.

1 embedded native SQL queryEmbedded SQL breaks query folding diagnostics and requires attention during database schema changes.

1 bidirectional relationship(s)Both-direction cross-filtering can introduce ambiguous filter paths and degrade DAX performance.

2. Data Model & Star Schema

Fact tables (blue) vs. Dimension tables (teal) • Hover or click any table to highlight relationships

flowchart LR
    classDef factNode fill:#e8f1fd,stroke:#0b63ce,stroke-width:2px,color:#0f172a;
    classDef dimNode fill:#e6f6f4,stroke:#0f766e,stroke-width:1.5px,color:#0f172a;
    classDef standaloneNode fill:#f8fafc,stroke:#94a3b8,stroke-width:1px,color:#334155;
    T1["[DIM] Dim Vendor (1 cols, 0 meas)"]
    T2["[FACT] Fact Spend (2 cols, 1 meas)"]
    T2 <-->|"VendorID = VendorID (*:1)"| T1
    class T1 dimNode;
    class T2 factNode;

Many / Fact Side	Cardinality	One / Dimension Side	Filter Direction	State
Fact Spend.`VendorID`	`* : 1`	Dim Vendor.`VendorID`	Both (Bidirectional)	Active

3. Data Sources & Tables Blueprint

Storage modes, source endpoints, business descriptions, visual Power Query pipelines, and column definitions

Table	Role	Mode	Connector	Endpoint / Database	Description	Cols	Measures	PQ Steps
Dim Vendor	Dimension	`import`	Excel, File	Excel: File.Contents, File: C:\Users\Public\VendorMapping_2025.xlsx	-	1	0	1
Fact Spend	Fact	`import`	SQL Server / Azure SQL 1 Native SQL	SQL Server / Azure SQL: sql-procurement-dev.northwind.internal	-	2	1	1

Dim Vendor

Dimension1 cols1 PQ steps

Column	Data Type	Origin / Source Column	Format	Description
VendorID Key	`string`	VendorID	-	-

Power Query Transformation Pipeline (1 steps)

1. SourceExcel.Workbook

View Power Query M Script - Partition Dim Vendor (import)

let
    Source = Excel.Workbook(File.Contents("C:\Users\Public\VendorMapping_2025.xlsx"))
in
    Source

Fact Spend

Fact2 cols1 PQ steps

Column	Data Type	Origin / Source Column	Format	Description
VendorID Key	`string`	VendorID	-	-
SpendEUR	`decimal`	SpendEUR	-	-

Power Query Transformation Pipeline (1 steps)

1. SourceSql.Database

View Power Query M Script - Partition Fact Spend (import)

let
    Source = Sql.Database("sql-procurement-dev.northwind.internal", "ProcurementDB", [Query="SELECT VendorID, SpendEUR FROM dbo.SpendLines"])
in
    Source

4. DAX Measure Catalog

Auto-formatted & organized by Table → Display Folder → Base Aggregations first, Derived KPIs second

Measure	Host Table	Display Folder	Tier	Format	Reads	Used By	DAX Preview
Total Spend	Fact Spend	General	Base	`#,##0`	1	0	`SUM('Fact Spend'[SpendEUR])`

5. Interactive End-to-End Live Lineage

Click any source, table, column, DAX measure, or report to trace live upstream & downstream impact

6. Row-Level Security (RLS), Downstream Reports & Access

0 RLS role(s) • 1 bound report(s)

No Row-Level Security (RLS) roles defined in this model.

Downstream Report	Report Workspace	Report Type
Vendor Rebate & Spend Variance	Supply Chain & Procurement Analytics	`PowerBIReport`