Connect to the Emissions Impact Dashboard for Microsoft 365
Calculate emissions from your tenant's usage of Microsoft 365 with the Emissions Impact Dashboard for Microsoft 365.
Accurate carbon accounting requires good information from partners, vendors, and suppliers. The Emissions Impact Dashboard for Microsoft 365 gives you transparency on the carbon emissions generated by your organization's usage of Microsoft 365. Microsoft's carbon accounting extends across all three scopes of emissions with a 3rd party-validated methodology.
To install the Emissions Impact Dashboard for Microsoft 365 in Power BI and connect it to your data, make sure you have the following:
- A business, enterprise, or education subscription for Microsoft 365 or Office 365.
- A Power BI Pro license. If you don't have a Power BI Pro license, get a free trial now.
- One of the following Microsoft 365 admin roles:
- Global admin
- Exchange admin
- Skype for Business admin
- SharePoint admin
- Global reader
- Report reader
In order to ensure that the report successfully refreshes over time, the Microsoft 365 admin credentials of the user who connects the application to your organization's data must persist over time. If that user has the admin role removed after the connection is established, the report will render demo data upon the next refresh.
The Emissions Impact Dashboard for Microsoft 365 is currently not supported for national cloud deployments including but not limited to Microsoft's US Government clouds and Office 365 operated by 21Vianet.
Included Microsoft 365 applications
The Emissions Impact Dashboard for Microsoft 365 reports datacenter emissions and active usage associated with the following applications:
- Exchange Online
- Microsoft Teams
Install the app
Click the following link to get to the app: Emissions Impact Dashboard for Microsoft 365.
On the AppSource page for the app, select GET IT NOW. You can also search for the app in Power BI.
When prompted, click Install.
When the app finishes installing, it will appear on your Power BI Apps page. Click on the app and open it.
Select Connect your data.
In the Connect to Emissions Impact Dashboard for Microsoft 365 dialog, enter your Microsoft 365 tenant ID. For help finding your tenant ID, see Find your Microsoft 365 tenant ID.
When done, click Next.
Connect your account:
- For Authentication method, choose OAuth2.
- For Privacy level setting for this data source, choose Organizational.
- When done, click Sign in and connect.
Select the user account. Make sure to sign in with the credentials that have appropriate admin access to your Microsoft 365 tenant (see list of approved roles above).
Wait for the view to build. This can take 24-48 hours. Refresh the dataset after 24 hours.
Update the app
Periodically you may receive update notifications from Appsource/Power BI about a new version of the app. When you install the new version, the following options are available:
Choose Update the workspace and the app, then click Install. This will install the update, overwriting the existing/installed workspace and app. After installation is complete, repeat steps 5-8 in the Install the app section above to re-establish the connection for the new app version.
If there are any issues with the dataset refresh/app update during the updating process, validate the following steps and refresh the dataset.
Follow the steps below to make sure your dataset configurations are set correctly:
Go to the workspace panel and open the app workspace.
Open the Scheduled Refresh option in the dataset settings.
Open the Parameters section and configure the data source once again in the Data Source section with the credentials with which you have access to the Tenant ID with valid permissions, mentioned in the prerequisites section above.
Once the above steps are validated, go back to the app workspace and click on the Refresh option.
Once the dataset has refreshed successfully, click the Update App option at the top-right corner of the app workspace.
To opt out of the Emissions Impact Dashboard for Microsoft 365, go to the Opt out tab in the app and follow the prompts. This step must be performed by a user with one of the roles listed in the prerequisites section above.
Within 48 hours of submitting your opt out request, go back to Power BI and delete the Emissions Impact Dashboard for Microsoft 365 app. If you don't perform this step, and the app does a data refresh more than 48 hours after your opt out request, your tenant will be opted back in to emissions processing.
If you opt out of the Emissions Impact Dashboard for Microsoft 365, you can always opt back in by re-installing and re-connecting to the app, but historical data will not initially be available.
- The carbon benefits of cloud computing: A study on the Microsoft Cloud in partnership with WSP
- Microsoft Sustainability webpage
Finding your company’s Microsoft 365 Tenant ID
Follow the steps on this page to find your tenant ID.
I'm receiving an error at the time of connecting my data with the dashboard. What can I do?
First, check in the Microsoft 365 Admin Center that you have one of the roles listed in the prerequisites section above. If you don't, request this access from your administrator. Next, ensure you're using the correct Microsoft 365 tenant ID.
I entered my tenant ID, but my company data isn't loading. What's the issue?
The Emissions Impact Dashboard for Microsoft 365 may take 24-48 hours to load your data after completing the connection process. Return after 24 hours and select the Refresh button in Power BI in the app workspace, as shown in the Issues section above.
I successfully connected to my tenant's data. Why do I still see demo data in the report, even after waiting 48 hours?
This could indicate that you don't have one of the Microsoft 365 admin roles listed in the prerequisites section above. Make sure that one of these roles is assigned to your profile, then open the app workspace and refresh the dataset (see further instructions in the Issues section above).
I successfully connected to my tenant's data. Why do I see blank data in the report?
This likely indicates that your tenant's emissions volumes are very small. The charts in this report do not display emissions values that are lower than 0.001 MTCO2e.
Why can't I see emissions data for the previous month?
Emissions data for a given month will be available by the 14th day after the end of that month (including non-business days). Ensure that your dataset is scheduled to refresh automatically on a daily or weekly basis so that you always have access to the latest information.
Why can't I see usage information prior to June 2022 in the Carbon Intensity tab?
Currently, information on Microsoft 365 usage is only available in the report from June 2022 onwards. For more usage history, see the Usage report in the Microsoft 365 Admin Center.
Why do I see emissions from regions outside of my Microsoft 365 data location?
Microsoft 365 emissions are allocated based on data storage as well as active usage and compute associated with Microsoft 365 applications. Emissions allocated based on compute may occur in regions outside your Microsoft 365 data location. Learn more about Microsoft 365 data residency here.
Where is the data used to produce this report stored?
It is stored in the United States.
What is the methodology behind the tool?
The Emissions Impact Dashboard for Microsoft 365 reflects the specific cloud services consumed and the associated energy requirements, efficiency of the datacenters providing those services, electricity fuel mixes in the regions in which those datacenters operate, and Microsoft's purchases of renewable energy. As part of the app's development, the methodology and its implementation went through third-party verification to ensure that it aligns to the World Resources Institute (WRI)/World Business Council for Sustainable Development (WBCSD) Greenhouse Gas (GHG) Protocol Corporate Accounting and Reporting Standard. The scope of the verification, conducted in accordance with ISO 14064-3: Greenhouse gases--Part 3: Specification with guidance for the validation and verification of greenhouse gas assertions, included the estimation of emissions from Microsoft 365 services, but excluded the estimation of on-premises emissions given the counterfactual nature of that estimate. A more detailed description of the carbon calculation is documented in the Calculation Methodology tab in the tool.
Characterizing on-premises emissions
Where does the Emissions Impact Dashboard for Microsoft 365 obtain data about my on-premises emissions and operations?
The Emissions Impact Dashboard for Microsoft 365 doesn't obtain any information specifically about your on-premises datacenters except what you provide. As described in subsequent FAQs, the Emissions Impact Dashboard for Microsoft 365 relies on industry research and user inputs about the efficiency and energy mix of on-premises alternatives to develop an estimate of on-premises emissions.
What are the assumptions regarding on-premises estimations? Are efficiency savings just from improvements in Power Usage Effectiveness (PUE)?
Efficiencies associated with Microsoft cloud services include far more than improved PUE. While Microsoft datacenters strive to optimize PUE, the primary efficiency improvements come from IT operational efficiency (dynamic provisioning, multitenancy, server utilization) and IT equipment efficiency (tailoring hardware to services ensuring more energy goes towards useful output), in addition to datacenter infrastructure efficiency (PUE improvements). Our 2018 study quantifies these savings compared to a range of on-premises alternatives ranging from low-efficiency to high-efficiency datacenters. These findings are used to estimate the energy use required for a corresponding on-premises datacenter to provide the same services that each customer consumes on the Microsoft cloud.
What is the assumed energy mix for the on-premises infrastructure?
By default, the Emissions Impact Dashboard for Microsoft 365 estimates on-premises emissions based on the mix of renewables and non-renewables on the grid. It is assumed that the on-premises datacenter would be located on the same grid as Microsoft's datacenters. However, for customers who purchase renewable electricity in addition to what's on the grid (for example, through Power Purchase Agreements), users can select the percentage of renewable electricity, and the Emissions Impact Dashboard for Microsoft 365 will adjust on-premises emissions accordingly.
When should I choose Low, Medium, or High for the efficiency of the on-premises infrastructure?
Users should select the efficiency most representative of the on-premises deployment they would like to compare against, based on the equipment and datacenter characteristics here:
- Low: Physical servers and direct attached storage in small localized datacenter (500-1,999 square feet).
- Medium: Mix of physical/virtualized servers and attached/dedicated storage in mid-tier internal datacenter (2,000-19,999 square feet).
- High: Virtualized servers and dedicated storage in high-end internal datacenter (>20,000 square feet).