1

Is anyone aware of a SSAS (tabular) 2016 in which the number of records in a table are not fully shown in Excel?

  • Say that when working in Visual Studio, a table has a rowcount of 740,000 records.
  • We process and deploy that table, but in Excel it shows only 12,000 records. also funny enough, when we deploy the model in VS it says that it only processed 12,000 records (yet the rowcount in the model is clearly 740,000 records).

(we ensure that Excel is connected to the deployed Tabular Model and not the user's workspace copy in Visual Studio)

  • We then change the table properties in VS to apply a filter, then we remove the filter, to see if this somehow "resets" this strange behaviour. It seems to do it.
  • However the problem seems to arise again during the next data load on the underlying database.

This only seems to happen with ONE table (all other tables are fine). So we tried recreating the table, but the same problem persists. Any idea of what might be causing this issue?

1

The solution was to change the processing in Visual Studio (VS) from Default to Full.

The issue is described in detail here: https://connect.microsoft.com/SQLServer/feedback/details/685325/processing-ssas-in-tabular-mode-not-refreshing-data (see Cathy Dumas's reply under "Posted by Microsoft on 8/25/2011 at 2:02 PM")

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.