Tabular Model - Full Process Not Getting All Data From Tables

• mchevallier

  SSC Rookie

  Points: 26

  More actions

  December 10, 2014 at 2:24 am

  #148776

  Hi

  I have had a very odd situation happen and a very odd thing fixed it. I'm not sure if I'm missing something relatively obvious or if I've discovered a bug.

  I have a Tabular Model running on SQL Server 2014. This tabular model draws data from a combination of tables and views. One of the views (Invoice) has a column, InvoiceStatus that was "I" for all rows. A row was added to the underlying table that had InvoiceStatus of "C" (1 row out of 5045). The view correctly reflected this change.

  Here's the strange thing:

  When I performed a Process Full on the tabular model, that particular row did not appear to be pulled through. According to the partition information for the table, there were 5,044 rows, not 5,045. I redeployed the model and performed full processes several times, but nothing appeared to pull the row through.

  Finally, I solved the issue by going into the partition on the table (which I did to verify there were no restrictions at that level, which there weren't) and performing a process on the partition. Upon completion of the partition process, 5045 rows were reported and the data was correctly reflected in the model.

  What gives? I'd have thought a Full Process should refresh all data, but in the specific case of this row, it didn't appear to. The only unusual thing about the row was the fact that it was the only InvoiceStatus "C" in an ocean of InvoiceStatus "I"s. Does anyone have any ideas?