Query data with Copilot in Microsoft Sustainability Manager

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.

Screenshot showing an example of querying data with Copilot.

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