ESG Reporting for FMCG, Packaging & EPC on Fabric

Most mid-market FMCG, packaging, and EPC companies do their ESG reporting in Excel. Energy consumption pulled from utility bills. Scope 3 emissions estimated from supplier emails. Packaging recyclability sourced from product spec sheets updated six months ago. Water usage from a facility manager's log.

This is not a compliance gap — it is a data architecture gap. The same problem that makes operational reporting slow and untrustworthy is the problem that makes ESG reporting slow and untrustworthy.

There is a common assumption that sustainability data is somehow separate from operational data — that it lives in a different system, is owned by a different team, and requires a different platform. That assumption is why most mid-market industrials end up with an ESG spreadsheet that is assembled once a year, audited under stress, and filed with a regulator before the data is thoroughly validated.

The reality is that most sustainability metrics are operational metrics viewed through a different lens. Energy consumption at a plant is an operational cost metric and an ESG metric simultaneously. Packaging waste is a production efficiency metric — it shows up in OEE calculations — and an ESG metric simultaneously. Supplier delivery performance is a supply chain metric and, when extended to include supplier emissions disclosures, a Scope 3 metric simultaneously.

The data is already there — in SAP S/4HANA, in SAP ByDesign, in Microsoft Dynamics 365, in the MES, in the WMS. The missing piece is a layer that connects it, governs it, and makes it visible in a form that can survive an audit.

Microsoft Fabric with OneLake as the data foundation is not purpose-built for ESG — it is purpose-built for any data that needs to be unified, governed, and made available for reporting. That is exactly what sustainability data requires.

The architecture is the same as an operational data deployment:

ADF pipelines ingest from source systems — utility meter APIs for energy data, SAP S/4HANA for production and materials consumption, procurement records from SAP ByD or Dynamics 365 for supplier spend and emissions factors, facility management systems for water and waste data.

All of that lands in OneLake as Delta Parquet tables, governed under the same data model as the operational estate. There is no separate sustainability data lake. There is no parallel reporting environment. There is one OneLake, one governance model, one set of semantic models in Power BI — and sustainability metrics sit alongside operational metrics because the underlying data is the same data.

Power BI then delivers two views of that data: the operational view (OEE, OTIF, fill rate, cost per unit) and the ESG view (energy intensity per tonne of output, Scope 1 and Scope 2 emissions, supplier-level delivery and emissions variance, packaging recyclability rate, waste per production run). Same semantic layer. Different perspectives.

The most immediate change is audit confidence. When energy consumption data flows directly from meter APIs into OneLake rather than being manually extracted from utility bills into a spreadsheet, the audit trail is automatic. The regulatory submission does not break because someone cannot find the original data source. Every figure is traceable to the ingestion pipeline, to the source system, to the raw event.

Procurement gains a new lens. When supplier-level emissions data is connected to the procurement record in the same OneLake estate, the procurement team can see — at vendor selection time, not ESG reporting time — which suppliers have high delivery variance and which have high emissions intensity. Scope 3 tracking moves from an annual exercise to an ongoing supplier performance dimension.

Packaging waste enters the OEE conversation. A packaging line running at 82% OEE because of high material waste rates is both an efficiency problem and a sustainability problem. When packaging waste data from the MES is in the same semantic model as OEE, the plant director can see both dimensions simultaneously. The conversation stops being "OEE versus ESG" and becomes "line efficiency, all-in."

Power Automate can alert the sustainability lead when energy intensity per tonne crosses a threshold — the same mechanism that alerts the supply chain manager about OTIF trend breaks. The platform does not distinguish between operational and sustainability signals; both are data, both get the same treatment.

The reporting requirements landing on mid-market FMCG, packaging, and EPC companies — BRSR Core in India, UAE Ministerial Decision sustainability disclosure requirements, CSRD scope creep through Tier 1 suppliers, SEC climate disclosure rules for companies with US-listed counterparts — are not asking for aspirational statements. They are asking for data with audit trails.

BRSR Core, which applies to the top 1,000 listed companies in India by market capitalisation and is cascading to their supply chains, requires business responsibility and sustainability reporting against specific metrics: energy consumption, water intensity, GHG emissions (Scope 1, 2, and 3), waste generated and disposed. Those are data fields — not qualitative statements.

A Microsoft Fabric deployment that connects these data points to OneLake and surfaces them in a Power BI semantic model produces the audit-ready output that regulators are asking for. An Excel-based process, by definition, cannot.

A flexible packaging manufacturer — approximately 600 employees, two production sites, SAP ByDesign as the ERP — was preparing for BRSR Core compliance and had no structured way to report GHG emissions below the annual estimate level. Energy data was in utility bills. Material waste was in a production log spreadsheet. Supplier emissions factors were not tracked at all.

A Fabric deployment that had originally been scoped for operational reporting — OTIF, OEE, and material yield — was extended over six weeks to incorporate sustainability metrics. ADF pipelines were added to pull utility meter data via API and to ingest supplier emissions factors from a standardised supplier questionnaire stored in SharePoint. The Power BI semantic model was extended with an ESG dimension, sitting on the same OneLake estate as the operational data.

At the end of the engagement, the sustainability lead had a Power BI report covering Scope 1 and Scope 2 emissions by site, energy intensity per tonne of output, material waste rate by production line, and supplier-level delivery performance. The annual BRSR Core submission, which had previously taken six weeks of manual data assembly, was produced in two days.

If your organisation is not running operations on Microsoft Fabric — if your operational reporting is still spreadsheet-based or if you have not yet built a Fabric estate — the ROI case for a sustainability-first Fabric deployment is harder to make. The economics work when sustainability data shares infrastructure with operational data. A standalone ESG data platform, separate from everything else, is both expensive and fragile.

If your primary sustainability challenge is strategy — defining material topics, engaging stakeholders, setting science-based targets — technology is not the first answer. The data platform is the reporting and audit layer. The sustainability strategy has to exist first.

If your supply chain is highly fragmented — hundreds of Tier 1 suppliers with no standard data exchange format — Scope 3 data collection will require a supplier engagement programme that goes beyond what a Fabric deployment alone can solve. The platform can manage the data once it arrives; collecting it from unwilling or under-resourced suppliers is a separate workstream.

The Discover phase maps which sustainability metrics are already in the operational data estate and which require new ingestion pipelines. In most mid-market FMCG and packaging companies, Scope 1 and Scope 2 data — energy and direct emissions — can be connected within four weeks because the underlying data exists in utility systems and ERP records. By week six, a Power BI dashboard covering energy intensity per tonne, Scope 1 and Scope 2 emissions by site, and material waste rate by production line is live and connected to OneLake.

Scope 3 and supplier-level emissions data is an Expand phase item — it requires supplier data collection processes that cannot be compressed into six weeks. That is the honest sequencing.