Tabular model row limit?

  • I'm trying to process and/or deploy a SSAS tabular model using Visual Studio 2010. One dimension is giving me grief; it hangs at 100,000 rows almost every time when I try to process it locally. Occasionally, about 1 time in 10 if I have killed and restarted VS, and if I Process All, I am able to get all of the 127,000 rows into the model, but then it hangs at 100,000 rows when I try to deploy it to the server. Is there a setting that I'm missing?

    Thanks,

    Jill

  • May be on Server, there might be a limitation on records that you need to increase the Dimension records count.

    OLAP\Query\DefaultDrillThroughMaxRows

    and also the RAM memory size also you may need to check out.

    Memory\VertipaqMemoryLimit

    Thank You

  • VRT (5/5/2015)


    May be on Server, there might be a limitation on records that you need to increase the Dimension records count.

    OLAP\Query\DefaultDrillThroughMaxRows

    and also the RAM memory size also you may need to check out.

    Memory\VertipaqMemoryLimit

    That setting is just for drillthrough. There is not row limit for tabular dimensions provided that no single column has more than 1,999,999,997 distinct values.

    https://msdn.microsoft.com/en-us/library/ms365363.aspx#bkmk_vertipaq

    It most probably is a RAM-related issue as VRT said. Have a look at the memory allocation of the AS instance (https://msdn.microsoft.com/en-us/ms174514.aspx) and up it if needed.


    I'm on LinkedIn

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply