Upload Tableau Workbooks for BI Optimization Datasets (Beta)

BETA FEATURE: BI Optimizer is a beta feature. Functionality, configuration steps, and supported options are subject to change as the feature evolves.

This article details how to upload Tableau Workbooks requested from Metric Insights to your Tableau environment. These Workbooks will then be used as sources for Datasets required for the Tableau BI Optimizer.

NOTE: We use Tableau Online as a demo environment. Instructions for Tableau Server may differ.

PREREQUISITES:

  • Credentials for accessing the internal Tableau database;
  • The latest Tableau Workbook files requested from [email protected]:
    • Tableau usage for 6 month 2.5.2025;
    • users-groups;
    • Permissions.

You will need to complete the following instructions for each of the Workbook files.

1. Upload Workbooks to Tableau

Access your Tableau account

  1. [New]
  2. Select Upload Workbook.
  3. Locate the Workbook file provided by Metric Insights support.
  4. By default, the Workbook inherits the file name. You can change it if needed, but using the default will make following the instructions to add Tableau to BI Optimizer easier.
  5. Specify the Project to create the Workbook in.
  6. Enable Show sheets as tabs.
  7. [Upload]

2. Provide Credentials to the Internal Database

  1. You may be prompted to provide the internal database credentials. Input them.
  2. [Sign In]

3. Embed Credentials

  1. Once signed in, navigate back to the Workbook details page.
  2. Proceed to the Data Sources tab.
  3. Access the Actions menu.
  4. Select to Edit Connection.
  5. Enable Embedded password in connection.
  6. [Save]