At this moment the "All Emissions"-table is not available via the dataverse connector. This means that the calculated emissions cannot be reported via Excel/PowerBI. To build customized dashboards it is necessary to make the virtual table available via the dataverse connector. The same goes for the activity-tables (fugitive emissions, stationary combustion etc). The current reporting in Sustainability Manager is not sufficient for our requirements. The only work-around at this moment is to export the full table from MSM to CSV-format and create a visualization of the data from this export.
Comments
In our environment, exports from all emissions take so long they regularly time out, meaning we have to export in small batches. This is bonkers that we can't report directly from the data, and exporting to an external table will be a massive manual effort.
Category: Microsoft Sustainability Manager