Dela via


Map data

The data import mapper table serves as the data mapping framework between Sustainability data solutions in Microsoft Fabric Metrics and external reporting in Microsoft Sustainability Manager. It aligns Corporate Sustainability Reporting Directive (CSRD) metrics in Sustainability data solutions in Fabric with concepts and the Unit of measure column in the ComputedESGMetrics table in Fabric OneLake to align with the units in Dataverse, adhering to standard requirements. Configuring this mapping is a crucial prerequisite for enabling CSRD metrics from the Sustainability data solutions in Fabric flow.

  1. In external reporting in Sustainability Manager, select the Advanced find button in the upper right.

    Screenshot of advanced find button.

  2. On the Select a table to search pane, select Data import mappers.

The Active Data import mappers page displays, showing the data import mapper records that are mapped to the CSRD metrics in Sustainability data solutions in Fabric.

Screenshot of Active Data import mappers 1.

Screenshot of Active Data import mappers 2.

Turn on the flow

Prerequisite: Connections should be established, and environment variables should be set.

  1. Go to Solutions > Managed > External ESG Reporting InterOp SDSF.

  2. On the left navigation, select Cloud flows.

  3. Select the ellipsis near Import CSRD Metrics From SDSF Flow, and then select Turn on. It can take a few seconds to update.

    Screenshot of turning on the flow.

Verify the flow is on

  1. Go back to the Power Apps portal.

  2. On the left navigation, go to Flows.

The flow originally disabled (grayed out) should now be turned on.

Screenshot of verifying the flow is on.

Next step