Prepare data for Sustainability data solutions in Fabric
This article outlines the steps to prepare your data in Sustainability data solutions in Microsoft Fabric for sustainability reporting. It helps you to:
Align your data with the Corporate Sustainability Reporting Directive (CSRD) standard.
Prepare a Power Automate flow before using the connector for integration with external reporting in Microsoft Sustainability Manager.
Prerequisite
Before proceeding with these steps, ensure that you have the lakehouse set up. Verify the presence of the following two SQL tables in the Microsoft Fabric lakehouse:
- ComputedESGMetrics
- MetricsDefinitions
Set up connections for Dataverse and SQL Endpoint
In the Power Apps portal, select your environment in the upper right corner.
On the left navigation, select Connections from the left navigation, and then select New connection.
Set up the Dataverse connection:
Search for Dataverse in the upper right search bar, and select Microsoft Dataverse. If there are two Dataverse connections, select the one that isn't grayed out.
Sign in, and then select Create.
Set up SQL Server connection:
Search for SQL Server in the upper right search bar, and then select SQL Server.
Sign in, and then select Create.
Under Authentication type, select Microsoft Entra ID integrated.
Link connections to the connection reference in the default solution.
On the left navigation, select Solutions, and then select Default Solution.
In the left navigation, select Connection references, and then from the options, select Dataverse connection for Metrics Import Workflow.
In the edit box that opens, select the Dataverse connection you created under the Connection dropdown.
In the left navigation, select Connection references, and then from the options, select SQL connection for Metrics Import Workflow.
In the edit box that opens, select the SQL Server connection you created under the Connection dropdown.
Select Save.
Set environment variables
Method 1
In Power Pages, navigate to Solutions.
A warning displays at the top stating 2 environment variables need to be updated. Select the link.
In the Environment variables pane, select Next.
Enter these values:
- Sustainability data solutions Fabric database name from Lakehouse > Settings > About > Name
- Sustainability data solutions Fabric server name from Lakehouse -> Settings > SQL Analytics Endpoint > SQL Connection String
Select Save and close. The warning should disappear.
Method 2
Go to Default Solution and then in the left navigation, select Environment variables.
In Environment variables, select Sustainability data solutions Fabric server name. Under Current server value, select New server value. In Current server, enter the server’s name from Lakehouse > Settings > SQL Analytics Endpoint > SQL Connection String, and then select Save.
Similarly, in Environment variables, select Sustainability data solutions Fabric database name. In the Server dropdown, select Sustainability data solutions Fabric server name. Under Current database value, select New database value. In Current database, enter the database name from Lakehouse > Settings > About > Name, and then select Save.
