Share via

Query data by using Copilot in Microsoft Sustainability Manager (preview)

Admin-led trial sign-up

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.

By querying data by using Copilot in Microsoft Sustainability Manager (preview), you can 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, see Overview of Copilot in Microsoft Sustainability Manager (preview).

Sample prompts

Try 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 by using Copilot

The following tables support querying data by using 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
  • Last updated on