none
Unable to update SSAS Tabular Model in SQL Server 2012

    Question

  • Hi,

    I am working on a BI production environment using SQL Server 2012, each time i create a new tabular model and deploy it, once there's an update in the  data source, if i try to update the model it does not update with recent data.

    Please i need your assistance.

    Thanks


    me

    Tuesday, November 06, 2012 3:54 PM

Answers

  • What processing option are you using when you refresh the data? If your model is not too large it's best to use processFull. If you use processDefault SSAS does not always re-read the source data. ProcessDefault actually does the minimum work possible to get the model to a fully processed state, so if your model is already processed a processDefault will not re-read the source data. It's only if you've done some sort of design change that invalidates the table that a processDefault will re-load the source data.

    It is quite confusing because the processing dialog reports " XXX rows transferred" -for processDefault, but sometimes this is just the existing number of rows in the tabular model, not fresh rows imported from the data source.


    http://darren.gosbell.com - please mark correct answers

    Wednesday, November 07, 2012 3:53 AM

All replies

  • What processing option are you using when you refresh the data? If your model is not too large it's best to use processFull. If you use processDefault SSAS does not always re-read the source data. ProcessDefault actually does the minimum work possible to get the model to a fully processed state, so if your model is already processed a processDefault will not re-read the source data. It's only if you've done some sort of design change that invalidates the table that a processDefault will re-load the source data.

    It is quite confusing because the processing dialog reports " XXX rows transferred" -for processDefault, but sometimes this is just the existing number of rows in the tabular model, not fresh rows imported from the data source.


    http://darren.gosbell.com - please mark correct answers

    Wednesday, November 07, 2012 3:53 AM
  • I have the same issue i have changed Project processing option to Full but still every time i process the table or all i get 0 rows transferred.
    Friday, December 28, 2012 10:18 AM
  • Use SQL Profiler to run a trace and see what SQL statement SSAS is firing off against the source database. Try running the same statement in SSMS and see how many rows come back

    http://darren.gosbell.com - please mark correct answers

    Thursday, January 03, 2013 1:07 AM