Skip to main content

Data Source Wizard

  • 2 minutes to read

The Data Source Wizard allows you to configure a data source for a Dashboard.

To invoke the Data Source Wizard, click the New Data Source button in the Data Source ribbon tab.

New Data Source

The start page allows you to select the data connection type. The following data connections are available in the Data Source Wizard:


The search panel allows you to filter the connection type list:

Custom connection string

Set the DataSourceWizardSettings.UseMergedConnectionTypePage property to true to use the wizard design illustrated above.

The XPO Data Source is hidden from the list of data sources available in the Data Source Wizard. Use the DashboardDesignerDataSourceWizardSettings.AvailableDataSourceTypes property to specify the data connections displayed on the page.

Users can configure the following data source types in the wizard:

Type Description
SQL Databases Different types of data providers to SQL data sources
OLAP OLAP cube in the Microsoft Analysis Services database
Entity Framework Microsoft Entity Framework
Object Binding A data object that implements the IList, IList<T> or IEnumerable<T> interface
Microsoft Excel workbook / CSV file Microsoft Excel workbooks (XLS, XLSX or XLSM files) or CSV files
Data extract A compressed snapshot of data from a regular data source
Data Federation A federated data source type that retrieves data from multiple data sources
eXpress Persistent Objects (XPO) DevExpress Object-Relational Mapping Library
JSON data Connects to JSON-formatted data
MongoDB Stores data in JSON-like documents
Custom Connection String Allows you to pass additional connection parameters and establish a connection to any SQL database.

Click Next to proceed to the next wizard page that depends on the selected data connection type.

You can customize this wizard to skip certain pages or change the list of available data providers. For more information, refer to the following topics: