Tableau Connector for Excel Services

Build 20.0.7695

Using Custom SQL Queries

Sometimes, only a subset of the data available in a Excel Services entity is needed. You can define any such subset using a custom SQL query.

Connecting to a Custom SQL Query

To create visualizations from a subset of the data available in a Excel Services entity, it will be necessary to author a unique SQL query. This can be done as follows:

  1. After you have connected to Excel Services, navigate to the Data Source tab.
  2. In the left pane, select your Database and Schema.
  3. Instead of selecting one of the available tables, click the New Custom SQL button.
  4. You will then be prompted for your query. Provide any filters aggregates or joins you want here. See SELECT Statements for syntax.
  5. Click OK.

With your custom SQL query provided, you can now proceed to Visualizing Data as if the selection were a normal table.

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 20.0.7695