Query data with Copilot in Microsoft Sustainability Manager
Microsoft Cloud for Sustainability - Free trial
Important
Some or all of this functionality is available as part of a preview release. The content and the functionality are subject to change.
Note
This feature is included in Microsoft Sustainability Manager Premium.
Querying data with Copilot in Microsoft Sustainability Manager allows you to quickly find answers to questions related to your organization's data.
For important considerations and instructions on how to add Copilot to your environment, go to Overview of Copilot in Microsoft Sustainability Manager.
Sample prompts
Try out some of these prompts with Copilot, or try creating your own:
- What organizational unit had the highest revenue in 2022?
- What's the GWP value of CH4 in AR5?
- How many imports failed in the past 30 days?
- Is there a factor mapping for vehicle type "Gasoline heavy-duty vehicles 2016"?
- How many calculation profiles are using AR4?
- How many goals under Carbon_reduction_plan_2030 are on track?
Supported tables for querying data with Copilot
The following tables support querying data with Copilot:
- msdyn_dataconnection
- msdyn_dataconnectionrefresh
- msdyn_calculationjob
- msdyn_goal
- msdyn_preparationreport
- msdyn_profilejob
- msdyn_profileallocationjob
- msdyn_reportingperiod
- msdyn_scorecard
- msdyn_accommodationtype
- account
- msdyn_businesstraveltype
- contact
- msdyn_contractualinstrumenttype
- msdyn_countryregion
- msdyn_disposalmethod
- msdyn_emissionfactor
- msdyn_employeecommutingtype
- msdyn_estimationfactor
- msdyn_facility
- msdyn_facilitycapacity
- msdyn_facilitycapacitydimension
- msdyn_facilitytype
- msdyn_facilityannualdetail
- msdyn_emissionlookup
- msdyn_fueltype
- msdyn_geographicarea
- msdyn_greenhousegas
- msdyn_industrialprocesstype
- msdyn_material
- msdyn_meter
- msdyn_organizationalunitrevenue
- msdyn_sustainabilityorganizationalhierarchy
- msdyn_sustainabilityorganizationalunit
- msdyn_spendtype
- msdyn_transportmode
- msdyn_unit
- msdyn_unitgroup
- msdyn_valuechainpartner
- msdyn_vehicletype
- msdyn_wastecharacteristictype
- msdyn_wastequalitycharacteristic
- msdyn_wastetype
- msdyn_waterbasin
- msdyn_waterinstrument
- msdyn_waterqualityanalysis
- msdyn_waterqualitycharacteristic
- msdyn_waterqualitycharacteristictype
- msdyn_waterriskindex
- msdyn_watersource
