Update Tabular model when new column added to table or view

Question

Hi

I have added a new column to the SQL server database source (a view), but when I reprocess affected table in Visual Studio it does not appear available for inclusion in Power Query editor or otherwise.

When I import the same affected table however, it does show up in the new table.

What can I do to refresh the model to include the new column succesfully? I do not want to redo all the relationships and measures from the old table to the new table each time my source schema is updated/changed.

Thanks

Answer 1

Hi @Anonymous ,

STEP1:For your case, try to test as next:

1. Choose "Import new table" but not really import a new one, just refresh as next:
   2.Or choose "Change the source" but not really change it just click ok.
   

STEP2:Follow the steps as next: Choose the table-->Table propertites-->Design-->Choose the new column-->Import.

Or you can follow steps as this case: update-tabular-model-when-the-underlying-relational-database-schema-changes

BR,
Mia

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Answer 2

Hi @Anonymous ,

Is the reply helpful?

BR,
Mia

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Answer 3

Hi @m

Apologies for the delayed response.

Thank you, it worked. Accepted as Answer.

Kind regards,
Niki