Data sources contain the data that you want to retrieve and use for analysis. This article details the required steps to add an Excel file as a data source.
|To use Excel files as a data source, you must ensure that the worksheet data is in list format. This means that the data must be set up in a database format consisting of one or more named columns.
Your license determines the number and type of data sources that you can connect to. A standard license permits a connection to one data source. Additional connectors can be purchased to permit the use of additional data sources.
Add Microsoft Excel Data Sources
1. In the Solution Explorer open the preferred business unit.
2. Right click on the Data Sources node then select Data Sources->Add Excel Data Source to display the Find Files or Folders dialog.
3. Navigate to and select the Excel file you want as data source, and then click OK .