Can I edit/add columns to the Common Data Model Entities?

[Don-Bot]

I am looking into using the common data model for some of our tables but there's not a 1-1 match up for the ones I want to use.  So was wondering if I could edit the entities to add columns that I have.  Similar to what you can do in Salesforce.  I'm currently researching this and haven't found anything yet.  So was wondering if I can and if so what the procedure is to do that.

Thanks

[v-yangliu-msft]

Hi  @Don-Bot ,

Are you referring to adding entity columns to a table already loaded in power bi?

Click on Transform data to go to the power query

Select the table where you want to add the column - APPLIED STEPs - Source - click on the + sign to add the new column.

This is the related document, you can view this content:

Add a column from examples - Power Query | Microsoft Learn

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Don-Bot]

Hi @v-yangliu-msft ,
No, I'm looking to see if I can edit the actual entity that I can choose from in map to CDM so that I can map the data to like columns.  If I map the columns and then go to try and re-add columns that weren't mapped it becomes a big cumbersome process.  So i want to see if I can simply edit the entity to add columns that Microsoft is missing so the CDM is useful to us.