[Expand]General Information
[Expand]WinForms Controls
[Expand]ASP.NET Controls and MVC Extensions
[Expand]ASP.NET Bootstrap Controls
[Expand]ASP.NET Core Bootstrap Controls
[Expand]WPF Controls
[Expand]Xamarin Controls
[Expand]Windows 10 App Controls
[Expand]Office File API
[Expand]Report and Dashboard Server
 [Expand]Get Started
 [Collapse]Basic Concepts and Terminology
   DevExpress Dashboard Architecture
   Dashboard Designer
   Dashboard Viewer
   Dashboard Items
   Data Sources
   Measures and Dimensions
   Desktop (WinForms and WPF) and Web Specifics
 [Expand]Common Features
 [Expand]Create the Designer and Viewer Applications
 [Expand]Create Dashboards
 [Expand]Visual Studio Integration
  End-User Documentation
 [Expand]Redistribution and Deployment
  Video Tutorials
 [Expand]Migration Guides
 [Expand]Member Tables
 [Expand]API Reference
[Expand]eXpressApp Framework
[Expand]eXpress Persistent Objects
[Expand]CodeRush Classic
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation
View this topic on docs.devexpress.com (Learn more)

Data Sources

To visualize data within Dashboard Items, you need to first establish a connection to a data source.

A data source collects underlying data and passes it to a data engine that performs aggregation and summarization before data analysis.

The DevExpress Dashboard allows you to use various data source types: traditional SQL databases, OLAP cubes, Excel and XML files, etc.

The following data source types are supported.

  • SQL Data Source

    Allows you to establish a connection to various types of SQL databases and to work with the connected data.

    In code, the SQL Data Source is represented by the DashboardSqlDataSource class.

  • OLAP cubes

    Provides the capability to connect to an OLAP cube in the Microsoft Analysis Services database.

    In code, use DashboardOlapDataSource.

  • Excel Data Source

    The Excel Data Source can be used to select data from Microsoft Excel workbooks (XLS, XLSX or XLSM) or CSV files.

    In code, use DashboardExcelDataSource.

  • Entity Framework Data Source

    You can connect to an Entity Framework data source defined within the current project or you can use an external assembly containing the required context.

    In code, use DashboardEFDataSource.

  • Object Data Source

    The Object Data Source provides the capability to connect to an object data source defined in a separate class within a current project.

    In code, use DashboardObjectDataSource.

  • Extract Data Source

    A data extract is a compressed snapshot of data from a regular data source. This data is saved to a local file and can be updated from the original data source at any time. For instance, you can work with a live SQL data source or you can use the Extract Data Source as an intermediate layer.

    In code, use DashboardExtractDataSource.

  • Federation Data Source

    The Federation Data Source establishes relationships and combines SQL Data Source queries, Excel Data Sources, and Object Data Sources to provide uniform access.

    In code, use DashboardFederationDataSource.


The DevExpress Dashboard uses database servers that can be configured to use case-sensitive table/column names. For this reason, a database scheme used in dashboards is case-sensitive to prevent any problem when the product is used with such servers.

Expanded See Also

Is this topic helpful?​​​​​​​