This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(252.8, 39%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMM%3C/text%3E%3C/svg%3E)
We have an AAS cube that - appears to be, based on underlying Views in the Azure SQL Database
I can add a column to a View fine in SQL, but I'm unsure how to promote that column to the AAS Cube.
Is there any sort of documentation? I'd love to do it in Tabular Editor 2 even...but I don't know if that's possible. This seems unusually difficult to google.
There is this page, but say when it says
https://video2.skills-academy.com/en-us/analysis-services/tabular-models/add-columns-to-a-table-ssas-tabular?view=asallproducts-allversions
"In the Power, click on the table you want to add a column to" - not really following. It doesn't seem to be specific to AAS either.
@Nandan Hegde Thanks!
Picking a random AAS table, the above is the query.
It doesn't seem like it's specifying particular columns, so in that case...if I just added a column to the underlying View table it's referencing (in this case FACTActualSales), that columns should automatically flow through, or?
yes, this is like Select * from table :)
Please accept it as answer in case if it helped as it might benefit other community members as well
Hello @Mark Mace ,
Just checking in to see if the below answer provided by @Nandan Hegde helped. If this answers your query, do click Accept Answer and Up-Vote for the same. And, if you have any further query do let us know.
Still missing something!
The last several months, I've added several columns to the views. But none of those columns seem to have been 'promoted' to the Cube.
I don't see them when when I connect to the cube via Power BI, nor Tabular Editor 2.
I've done [Process Default] & [Process Full]
Going to the table > Partition is new to me, thanks.
Here's a screenshot of the cube & underlying database - just confirming they cube uses the same db as the one I've been editing views in. Kinda confused.
Thanks! Still missing something.
I've added many columns to the Views the last several months. But none, are getting 'promoted' to the cube. I have done [Full Process] on the cube, etc.
All the scripts behind the cube tables seem to be of the 'select *' variety
And here's a screenshot of the cube & underlying DB. Not really sure what I'm missing -
Hey,
Login to the AAS server via SSMS
expand the TBM to tables and right click on the table wherein you want to add the column and click on partition
click on Edit :
Update the query and click on OK
Another way would be via visual studio code in case if you are maintaining the code
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(246.4, 44%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETL%3C/text%3E%3C/svg%3E)
Hey @Mark Mace ,
I'm not sure if this is still something you'd like to do, as it's also a late reply, however, if you want to add a new column in Tabular Editor (2), you just need to refresh the table metadata (doesn't matter if it's a view or table). You can also do a general refresh of all tables metadata, which will also tell you if any column definition/data type has changed.
If you get an error saying it's unable to validate it's source, you just need to re-enter the password in the data source:
Hope it helps, if you do decide to use Tabular Editor :)
Got it. For whatever reason - after doing the above, I have to go into Visual Studio, & Refresh. Then Import, save, and Deploy solution.
Nice! Though, I don't seem to have those menu options in Tabular Editor 2.17.2? (I just did a quick update, just in case)
Hi!
I have 2.16.7. You can try by going into the partition as well. Example:
Or you could try right clicking on the "Tables" folder, and see if you have the "Refresh table metadata" option?
Nope, no options under either partition, nor Tables folder.
Are you connecting to an AAS Cube, or SASS Cube? (Just wonder if that's the difference)
