Add table partitioning for SSAS Tabular model

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.

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

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.

But remember it's an Enterprise feature. 

https://docs.microsoft.com/en-us/analysis-services/analysis-services-features-supported-by-the-editions-of-sql-server-2016?view=asallproducts-allversions 

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.

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.

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

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

A potential workaround is to implement partitioning via a PowerShell script, the ability to execute PowerShell scripts was released in version TimeXtender Data Integration 6024.1. 

Hi @Christian Hauggaard . But how about execution of the semantic model? It always does a full model execution, so it will also include the partitions every day that only are needed to be reloaded every month for example.

Hi @sven.debie can the Powershell command Invoke-ProcessPartition not be used for this?

Yes, using PowerShell, in combination with Tabular Editor scripts, it’s possible to decide what type of model refresh to do.

Hi @Christian Hauggaard , 

The creation of the partiotions cannot be done using TimeXtender. It would be great if we can do this in TimeXtender as well.