Events
Nov 19, 11 PM - Nov 21, 11 PM
Discover the latest partner benefits with product enhancements to support AI practice growth at Microsoft Ignite online.
Register nowThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Follow the steps in this article to bring your organization’s environmental data from the Microsoft Sustainability Manager data model in Dataverse to the IngestedRawData lakehouse in your Fabric workspace by using a Fabric link.
In this step, you set up a link to Microsoft Fabric between the Sustainability Manager environment from which you want to bring your data and the Sustainability data solutions in Microsoft Fabric workspace.
Open the Power Apps portal. On the top right, select your Dataverse environment where Sustainability Manager is installed.
Select Tables from the left pane and select Analyze, and then select Link to Microsoft Fabric on the command bar.
In this step, you create shortcuts in the IngestedRawData lakehouse for the Sustainability Manager tables that you want to transform into the environmental, social, and governance (ESG) data model.
Open the workspace in Fabric where you deployed the Sustainability solution. To open the solution, select it from the list view. Select the ESG data estate capability from the Manage deployed capabilities list view to reach the managed capability page.
From the ESG data estate managed capability page, select the IngestedRawData lakehouse.
The tables are now available in the IngestedRawData lakehouse and are ready to be transformed into the ESG data model.
After the Sustainability Manager data integrates into the IngestedRawData lakehouse, unify and harmonize the data by transforming it into the ESG data model schema. During deployment, the ProcessedESGData lakehouse was created in the workspace for storing the harmonized data. The ESG data model schema links the ESG data entities to other data entities that describe other functional areas of a company, such as HR, IT, or finance production.
For transforming Sustainability Manager data to the ESG data model schema, the capability provides notebooks and data pipelines that use prebuilt transformation and orchestration technologies using libraries stored in the ConfigAndDemoData lakehouse in your workspace.
Run the TransformMSMDataToProcessedESGData_DTPL data pipeline to load and transform the Sustainability Manager data to the ESG data model schema in the ProcessedESGData lakehouse.
The first step is deactivated by default and isn't required for this method, because the data from Sustainability Manager is already loaded as lakehouse tables.
The transformation of the Sustainability Manager data to the ESG data model schema is a two-stage process:
Events
Nov 19, 11 PM - Nov 21, 11 PM
Discover the latest partner benefits with product enhancements to support AI practice growth at Microsoft Ignite online.
Register nowTraining
Module
Link your Dataverse environment to Microsoft Fabric - Training
Learn how to link your Dataverse environment to Microsoft Fabric.
Certification
Microsoft Certified: Fabric Data Engineer Associate - Certifications
As a fabric data engineer, you should have subject matter expertise with data loading patterns, data architectures, and orchestration processes.