Skip to main content
Submitted

Add table partitioning for SSAS Tabular model

  • November 20, 2018
  • 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
  • September 23, 2019

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
  • January 15, 2020

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
  • November 1, 2020

Forum|alt.badge.img
  • Participating Frequently
  • May 28, 2021

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
  • October 26, 2021

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
  • August 9, 2022

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


  • New Participant
  • August 10, 2022

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