Forum Discussion
add column to existing data model
Due to some changes in my organization, there is a need to add columns an existing data model. I am wondering if there is a way to add these coulmns to the model through the query editor. To my ...
If you didn't filter your columns in the query, the new columns should show up in the data model when you refresh the data from the source (assuming this is where the columns were added. If you need to add them to the actual data model itself, you can use calculated columns in the query editor or in the data model itself using DAX.
I should have mesntioned this in the beginning but the columns I would need to add will come from Dynamics CRM. Is there still a way to connect to that data source through the query editior and add the columns to the already existant table? If so, how?
Thanks!
If you add columns to your data source (regardless Dynamics CRM), and refresh your query, it will bring new columns. Did you tried this?
