Forum Discussion
Helper VCan I edit/add columns to the Common Data Model Entities?
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
2 Replies
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-BotHi Anonymous ,
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.
