Extension of MSM data model

Like (3) Share

Report

Posted on 27 Mar 2025 16:10:17 by Lea Kraus

111

Hi team,

I would like to extend the data model of the MSM. I need to add a new column to the table "Facilities" to capture the area size. Following the documentation (Extend the Cloud for Sustainability data model - Microsoft Cloud for Sustainability | Microsoft Learn), my plan is to create a new unmanaged solution, add the table "Facilities" and create the new column there.

1. Is this the right way to extend the data model?

2. What happens if the MSM and the table "Facilities" gets updated by the regular MSM updates from Microsoft? Will the new column be overwritten with the update or will it remain?

Thanks is advance for you help, always appreciated!

Cheers,

Lea

Categories:

Sustainability Manager

All responses (2)

Answers (1)

Suggested answer

Joke Laukens 70 on 31 Mar 2025 at 09:55:32

Like (0)

Report

Extension of MSM data model

Hi @Lea Kraus,

Just wondering..

Can Facility Usage Detail help?

That entity has area included.
Verified answer

Ivan (Vanya) Kashperuk on 28 Mar 2025 at 02:13:55

Like (1)

Report

Extension of MSM data model

Yes. That is the right way.

And no, the newly added column will not get overwritten with the future updates, as it will be in a lower layer compared to your changes.

These changes you'd make in your DEV and then ideally package in a managed solution and upload to UAT/PROD as a managed solution.