Skip to main content
Submitted

Add table partitioning for SSAS Tabular model

  • Nov 20, 2018 10:50 AM UTC
  • 8 replies
  • 3 views

Forum|alt.badge.img

Add feature to enable table partitioning in SSAS tabular models.

8 replies

Forum|alt.badge.img
  • Participating Frequently
  • Sep 23, 2019 3:59 PM UTC

This would be very useful, as there doesn't seem to be a way to process a tabular model without fully loading, which isn't an option with very large models.


Forum|alt.badge.img
  • Known Participant
  • Jan 15, 2020 9:34 AM UTC

We need this as well - processing a 300M records table is not something you want to do every run.

 


Forum|alt.badge.img

We need this urgently, else we are forced to stop using TimeXtender for developing and processing semantic layers. Processing multiple large tabular models daily is just not workable.


Forum|alt.badge.img
  • Known Participant
  • Nov 1, 2020 5:45 PM UTC

Forum|alt.badge.img
  • Participating Frequently
  • May 28, 2021 1:28 PM UTC

It's an enterprise feature or if you're on Azure you need at least the Standard price tier.
But once you have that, we use a simple Powershell script which uses the AMO objects to modify the tabular model and you can run manually or trigger it after a deployment. This script partitions every table in a model which isn't partitioned yet. The partitioning is automatically done on the modulo of the DW_id column if it doesn't exist yet.

 


  • New Participant
  • Oct 26, 2021 9:01 PM UTC

We really need this. Especially now we are putting historical tables on AAS. It takes forever before the model is updated with all history. So this is really an important feature that is missing.


  • New Participant
  • Aug 9, 2022 3:29 PM UTC

Any news on this feature? It is badly needed and completely basic.


  • New Participant
  • Aug 10, 2022 11:17 PM UTC

We begged for this feature three years ago. Please implement it! Partitioning and Execution in SSAS Tabular – TimeXtender Support