Version 2021

Import Data

You can import data directly into a new or existing dataset, for use in creating dossiers. A dataset contains the data you display on a dossier. In addition, you can select multiple tables to create a single, multi-table dataset. MicroStrategy Workstation also allows you to combine different types of data sources in a single dataset. This includes combining data from an Excel spreadsheet and relational database table into a single dataset. You can also add a custom connector previously created in MicroStrategy Connector SDK. See Manage Datasets for more information about managing data in your dossier.

If a data source is not available, you may not have the correct privileges to view it. Contact your administrator for help.

You can hide and display different data sources and databases, so that only the options that you use regularly appear. See How to Display and Hide Data Sources and Databases for Data Import for more information.

Learn more about importing data by selecting one of the following topics: