Blogs from Wise Owl on Partitions and processing in SSAS tabular

Five methods for creating partitions of SSAS Tabular tables programmatically

Posted by Andy Brown on 23 July 2018

Need to generate a partition for a fact table for each year, product or region? This blog gives five approaches, so that you can choose which method is for you.

Using partitions/processing to load a large fact table into a tabular data model

Posted by Andy Brown on 23 July 2018

This blog shows how you can load the empty structure of a large fact table into an Analysis Services tabular data model, then use partitions to bring in the data bit by bit.

Find how to use table partitions in SSAS Tabular to process data more quickly

Posted by Andy Brown on 19 February 2016

You can partition a table in SSAS Tabular, which involves processing it in chunks rather than in one fell swoop. This blog explains how partitions work, and how to set them up and use them.

How to process tables in your model, and ideas for speeding processing up

Posted by Andy Brown on 19 February 2016

Processing tables involves loading data into your model, and can take a long time. This blog explains how processing works in SSAS Tabular and the different options available to you, shows how to process tables or models, and gives some ideas on how to make processing run more quickly.