Hello,

Please how can i automatically update my tabular model in the future when there's an update in my database.

Thanks

To automate tabular models you can use AMO with C#, VB or powershell:

http://tabularamo2012.codeplex.com/

This can be planned as:

• Maintain a log table with a staus value (Update Pass or Update Fail) for the database when ETL is scheduled
• Schedule a SQL Agent to begion Process (Full/Add) on the model only when the latest entry in the log table is = Update Pass, else wait and poll again after a definte period.

Hi,

You can create a SSIS package in which there is an Analysis Services Processing Task that will automatically process the SSAS tabular model .As simple as that.You can run this package either manually after an update or you can schedule a SQL job that runs at a predefined time daily based on your scheduled ETL

(Though it may be too late for a reply to be helpful for the said user,I have replied regardless of it.So people who come across same/similar question can implement it) Hope it helps.