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(86.4, 84%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETW%3C/text%3E%3C/svg%3E)
I am using Visual Studio 2019 to build a SSAS Tabular Model from a database in MS SQL Server 2019. The SQL server is on the local computer.
I connected to the MSSS and imported a table.
Then a new column was added to the table in MSSS.
I can go into the model to Table Properties --> Design --> Query --> Refresh Preview (ALL) and the column will appear on in the table in the query WITH all of the data.
I Import the query and it appears to be successful. After closing the Table Properties, I return to the model and view the data in the table. The column is there; however NONE of the data appears.
How do I add a new column to an existing model?
TIA,
Terry
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
![](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(73.60000000000001, 21%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDB%3C/text%3E%3C/svg%3E)
Did you reprocess the table after adding the column?
Did you reprocess the table after adding the column?
Thanks David, I'm really not sure what you mean by this? I'm not ready to build a solution yet. I did import the table from the query.
Answer accepted by question author
In Visual Studio you're always working against an SSAS instance, and changing the source query doesn't automatically cause the SSAS to reload or "process" the data in the query. PowerBI Desktop always does these two steps together, but in Visual Studio they are seperate and you must reprocess the table to see the new column populated.
Thank you!!! This is exactly what I needed.