Configuration of DAX Studio

1. Open an Excel workbook.
2. Open a Power BI Desktop file.
3. From the Add-Ins tab of the toolbar, activate DAX Studio.

1. Close the Excel workbook.
2. Launch the DAX Studio standalone Windows application.
3. Connect to a Power BI Desktop file or SSAS Tabular instance.

The Advanced Options settings of the Connect dialog establishes a connection in the context of the Sales Territory-North America security role defined in the model.

1. Enable the DirectQuery Trace setting from the Options menu (File | Options).
2. This provides visibility to the SQL queries passed from DirectQuery models.