Change the DirectQuery Partition (SSAS Tabular)

Because only one partition in a table can be designated as the DirectQuery partition, by default, Analysis Services uses the first partition that was created in the table. During model project authoring, you can change the DirectQuery partition by using the Partition Manager dialog box in SQL Server Data Tools (SSDT). For deployed models, you can change the DirectQuery partition by using SQL Server Management Studio.

Change the DirectQuery partition for a tabular model project

  1. In SQL Server Data Tools, in the model designer, click on the table (tab) that contains the partitioned table.

  2. Click on the Table menu, and then click Partitions.

  3. In Partition Manager, the partition that is the current DirectQuery partition as indicated by the prefix (DirectQuery) in the partition name.

    Select a different partition from the Partitions list, and then click Set as DirectQuery.

    Note that the Set as DirectQuery button is not enabled if the current DirectQuery partition is selected. Also, the button is not visible if the model has not been enabled for DirectQuery mode.

  4. If necessary, change the processing options, and then click OK.

Change the DirectQuery partition for a deployed tabular model

  1. In SQL Server Management Studio, open the model database in Object Explorer.

  2. Expand the Tables node, right-click the partitioned table, and then select Partitions.

    The partition that is designated for use with DirectQuery mode has the prefix (DirectQuery) on the partition name.

  3. To change to a different partition, click the Direct Query toolbar icon to open the Set DirectQuery Partition dialog box.

    Note that the DirectQuery toolbar icon is not available on models that have not been enabled for DirectQuery.

  4. Choose a different partition from the Partition Name dropdown list, and then change processing options on the partition if necessary.

See Also


Partitions (SSAS Tabular)