Microsoft demonstrates a SharePoint-to-Fabric medallion data pipeline
Microsoft’s new Fabric walkthrough shows how Excel files arriving in SharePoint can become traceable historical data and analytics-ready customer summaries.
Dataflow Gen2 discovers qualifying workbooks and loads staging data; notebooks then build Bronze, Silver and Gold layers in dedicated lakehouses.
The example retains filenames, source modification times, ingestion timestamps and record hashes. Comparing hashes prevents repeated ingestion from appending the same historical observation.
Silver standardizes records and selects the current customer view, while Gold prepares dashboard aggregations. The lab uses customer sample data; vendor profiles, contracts, spend and risk are proposed applications of the pattern.
Partner briefing
- What it is
An end-to-end SharePoint Excel ingestion and Fabric medallion architecture walkthrough.
- What’s changing
Demonstrates Dataflow Gen2 staging, historical Bronze records, standardized Silver entities and Gold dashboard measures.
- Why it matters
Shows source lineage and hash-based change detection while separating raw history from current business data.
- Who it affects
Data engineers and analytics teams building file-based customer or vendor intelligence pipelines.