SSAS Tabular Cube partitioning - number of partitions

by Tomasz Wieczorkowski   Last Updated May 19, 2017 10:06 AM

We ha a Fact table with 500 milions of rows (data from 10 years - 60GB). I've partitioned this table on database level and SSAS Tabular Cube level as well - one month per partition to improve the overall browsing performance and SSAS Cube processing time. But last time I've heard that configuring more than 2 partitions for SSAS Tabular cube is not good. There should be max 2 partitions per tabular cube. Have you heard about something like that ? Is that true ?

Related Questions

How make an SSAS Tabular model case sensitive?

Updated August 10, 2017 10:06 AM