O'Reilly logo

Microsoft Tabular Modeling Cookbook by Paul te Braak

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Processing the data

Creating a partition (as explained in the Creating and managing partitions recipe) creates a definition of the partition (in model metadata). Once this is done, the data must be loaded into the partition if it has to become viewable. Furthermore, changes to the underlying data are not reflected in the model until the partition is processed.

Consider the situation where data is partitioned at the source database. This could be by table, partitions within tables, or views (or various combinations of these). For example, assume that we have the sales data separated in views by year, as shown in the following screenshot:

Processing the data

The partitioning ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required