Issue Adding a Data Column to Model in Tabular Editor

[WonkyMeister]

Hi guys.

New role, not used Tab Editor before (or Power BI). I'm having issues when deploying my model to power BI.
Steps:
Created a new field in SQL (case statement)
Tested code in Sql Server
Added code to table script in Tab Ed
Right clicked on table in Tab Ed, added new data column
Amended appropriate properties to data column (source column, data type etc)
Saved
When i refresh the table meta data, the "Change Description" column lists as 'remove Column' - which i don't understand
Deployed
Refresh Power BI
get a fail message from power BI that the field doesn't exist.

what am i missing in the step process?

cheers in advance

[mlonsk]

Hi @WonkyMeister
Thanks for reaching out, and congrats on the new role.
Just to clarify, are you using Tabular Editor 3?

If so, instead of manually updating the column, try using the "Update Schema" in the right-click menu of the table you want to add the column to:

What is the result you get when doing that? Can you see the new column as an addition there? If you accept and deploy those changes, does the error still occur?
If the column does not show up, this, along with your original issue, indicates to me that the column has not been correctly added to SQL Server. Could the model, for example, be pointing to a different SQL Server (e.g., Prod instead of Dev)?
Best
Morten

[WonkyMeister]

Hi, thanks for the reply!

i'm using Tab Ed 2.28.0 (free version i think)

be really useful for someone to give me a bullet list, step by step process of how to add a new field if i'm honest. My SQL is fine (tested). I just dont understand why Power BI throws an error when i deploy and refresh?