Strategy One

Preview Feature: Import Data from Microsoft Analysis Services

Strategy One (January 2026) adds a preview feature for enhanced security for Microsoft Analysis Services (MSAS) integrations. You can validate OIDC tokens on the Internet Information Services (IIS) and MDX cube provider after you have been validated in Entra ID.

Enable the Preview Feature

  1. Open the Workstation window.

  2. Log in to your environment.

  3. Click Help and enable Preview Features.

Create a Microsoft Analysis Service Data Source

  1. Open the Workstation window.
  2. In the Navigation pane, click , next to Data Sources.

  3. Click Microsoft Analysis Services.

  4. Type a Name.

  5. Expand the Default Database Connection drop-down list and click Add New Database Connection.

  6. Type a Name.

  7. Expand the Driver drop-down list and choose a Driver.

  8. Enter your URL, Data Source Information, and Catalog.

  9. Expand the Default Database Login drop-down list and choose a login.

  10. Optionally select the check box next to Enable OIDC validation on effective user name and choose an Authentication Service.

  11. Optionally select the check box next to Enable SSAS database authentication and enter a User and Password.

  12. Click Save.

  13. Click Save.

Import Data

  1. Open the Workstation window.

  2. In the Navigation pane, click , next to Datasets.

  3. Select your environment and project, Data Import Cube, and click OK.

  4. In Data Catalog, expand the OLAP section.

  5. Expand your MSAS data source and double-click cubes or drag them into the right pane.

  6. View the cubes to import in the right pane.

  7. Click Save.

  8. In Browse Catalog, expand the cube and drag the tables you want to add into the right pane.

  9. If you want to use hierarchy reporting, select the check box next to Import hierarchy as hierarchical attribute.

    For more information on hierarchical attributes, see Import Hierarchical Attributes.

  10. Click Finish.