Preview Feature: Connect to Excel

Starting in Strategy (November 2026), you can connect your Mosaic models to Excel.

Preview features are early versions of features and are not to be used in a production environment as the core behavior remain subject to change between preview and GA. By selecting to expose preview features, you can access and use them as you would any other functionality. The official versions of preview features are included in subsequent releases. For access to this feature, contact your account team.

Prerequisites

Enable the feature flag:

  1. Go to your Mosaic Universal Access service: <mosaic service>/etc/config.properties

  2. Add the following property: xmla.mdx.enabled=true

Connect to Excel and Import Data

  1. In the Strategy Library Navigation pane, click Data.

  2. Locate your Mosaic model and click Additional Information .

  3. Click the Universal Access tab.

  4. Under Power BI, ensure SQL Server Analysis Services is selected in Connector Type.

  5. Next to Server, click Copy .

  6. Open your Microsoft Excel workbook.

  7. In the top navigation, click Data.

  8. Expand Get Data.

  9. Choose From Database and From Analysis Services.

  10. In 1. Server name, paste the value you copied from Library in step 5.

  11. In 2. Log on credentials, select Use Windows Authentication.

  12. Click Next.

  13. Expand the Select the database that contains the data you want: drop-down list and choose the Strategy project that includes the model you want to import.

  14. Select your model and click Next.

  15. Review the data connection file information and edit the name and description, as needed.

  16. Click Finish.

  17. In Import Data, choose how you want to view and where to put the data.

  18. Click OK.

    You Strategy data imports in Excel.

  19. In the right pane, select the data you want to add to your worksheet and customize your display, as needed.

Known Issues

  • MDX calculated members do not display in filter drop-down lists.

  • If you add an MDX calculated member on an attribute hierarchy into a PivotTable and refresh the PivotTable, an error displays.