Forum Discussion

RE's avatar
RE
Icon for Helper I rankHelper I
9 years ago

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 ...
Need Help
Tutorial Requests
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
9 years ago

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.

RE's avatar
RE
Icon for Helper I rankHelper I
9 years ago

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!

  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper User
    9 years ago

    If you add columns to your data source (regardless Dynamics CRM), and refresh your query, it will bring new columns. Did you tried this?