There are two kinds of Data Sources that can be created: Local Data Sources and Live Data Sources.
Local Data Sources are Data Sources whose data needs to be imported into a local in-memory database before it can be used. Live Data Sources are Data Sources whose data can be queried directly.
Here is a list of supported local and live Data Sources:
| Local Data Sources | Microsoft Excel |
| Microsoft Access |
| Comma Separate Value files (CSV) |
| Amazon Simple Storage Service (S3) Logs |
| Google Spreadsheets |
| Live Data Sources | Microsoft SQL Server |
| Oracle |
| MySQL |
| Microsoft Analysis Services (OLAP) |
When a dashboard is created over a local Data Source, the data is imported from the source into an in-memory database. Therefore, the dashboard file will also contain the imported raw data.
This is not true in the case of live Data Sources. When a dashboard is created over a live Data Source, the source is queried directly for results and therefore the raw data is not included with the dashboard file.