How would I update a table in the cube after I've added a new column?

amzzz 61 Reputation points
2022-07-30T00:02:22.477+00:00

I've added a column to the view that the table in the AAS Tabular model uses as the source. Would I have to go in and add the column to the table in the cube in order for the new column to be processed or will the cube just update based on the update made to the view which is used as the source for the table?

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
444 questions
SQL Server Analysis Services
SQL Server Analysis Services
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.
1,263 questions
0 comments No comments
{count} votes

Accepted answer
  1. Joyzhao-MSFT 15,571 Reputation points
    2022-08-01T03:34:18.993+00:00

    Hi @amzzz ,
    Do you mean that a column is added to a table in the database and that table is used as the data source for the Tabular Model?
    If so, you can do as follows:
    Edit Table properties:

    226585-01.jpg

    Refresh Preview and check new column, then click "OK":

    226545-02.jpg

    Or see more: Update Tabular Model when the underlying Relational Database schema changes.

    If I misunderstand what you mean, please feel free to corret me.
    Best Regards,
    Joy


    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. amzzz 61 Reputation points
    2022-08-01T13:38:40.99+00:00

    I've figured it out, thanks!

    0 comments No comments