Enable DirectQuery Design Mode (SSAS Tabular)

To create a model in DirectQuery mode, you must first change the design-time environment so that it supports DirectQuery mode. When you do so, the designer will also do the following:

  • Enable the use of the DirectQuery deployment properties.

  • Change the workspace database to run in a hybrid mode that uses the cache for designing. When you actually deploy the model, the mode will be changed back to whatever value you specified in the project deployment properties.

  • Disable design features that are incompatible with DirectQuery mode.

  • Validate the existing model.

This procedure describes how to enable DirectQuery mode in the designer.

To enable use of DirectQuery in a model

  1. In SQL Server Data Tools (SSDT), open the solution file.

  2. In Object Explorer, double-click the Model.bim file.

  3. In the Properties pane, change the property, DirectQueryMode, to On.

  4. If there are errors, in Visual Studio, open the Error List and resolve any problems that would prevent the model from being switched to DirectQuery mode.

See Also


DirectQuery Mode (SSAS Tabular)