The Tabular Select transform is created when you drag a structure onto the data cube canvas from a data connector that supports tabular data (e.g., Excel, XML, SQL Server table-valued functions).
The structure of the table dropped on the data cube canvas is used as input. The following example is used in this article:
2. Add the transform
Find an existing data connector in the Explore window and drag and drop one of its tables. You can also drag and drop a file to the canvas from Windows Explorer or Finder.
To configure the transform, select it and choose Configure in the toolbar.
The Tabular Select configuration dialog appears.
Select which columns from the table should be included in the output of this transform.
The Timeout can be customized to change the length of time in seconds before terminating a long-running query.
If your data source defines parameters, such as an OData connector's query options, you can click Define parameters to set these. (A gear icon is displayed in the corner of the transform on the canvas to indicate they are available.)
With the transform selected, open the Data Preview window to see the output.