Skip to main content

Data Connections

Creating a Tableau Connection

You can connect Tableau to the Analysis Server to create highly customized reports. This guide shows the steps to guide you in the process.

  1. Open the Tableau application.

  2. In the right pane, under the To a Server connection, click More..., then select Microsoft SQL Server Analysis Services.

    Getting Data from Analysis Services

    Getting Data from Analysis Services

  3. Fill in the Server field, then click Sign In.

    Specifying Server to connect to

    Specifying Server to connect to

  4. Choose the database and cube to use, then click Go to Worksheet.

    Specifying the Database and Cube

    Specifying the Database and Cube

    A worksheet will be ready for report creation.

    Empty Worksheet

    Empty Worksheet

Modifying the Data Connection

  1. In the Data tab, select New Data Source.

    New Data Source

    New Data Source

  2. In the To Connect window, under the To a Server connection, click More..., then select Microsoft SQL Server Analysis Services.

    Getting Data from Analysis Services

    Getting Data from Analysis Services

  3. Fill in the Server field, then click Sign In.

    Specifying Server to connect to

    Specifying Server to connect to

  4. Choose the database and cube to use, then click Go to Worksheet.

    Specifying the Database and Cube

    Specifying the Database and Cube

    A worksheet will be ready for report creation.

    Empty Worksheet

    Empty Worksheet

note

Refer to the official Tableau documentation for a more comprehensive Tableau data connection guide.