MicroStrategy ONE

Importing Data from a File on Your Computer or Network

If you arrived here from Workstation, see the Workstation Document Authoring Help.

You can import data from a file, such as an Excel spreadsheet or text file, to create a dashboard.

Your data must be in one of the following file types:

  • .xlsx
  • .xls
  • .txt
  • .csv
  • .tsv
  • .prn
  • .json
  • .sas7bat
  • .geojson
  • .kml
  • .xml - Files must be under 2 GB.

Password-protected or compressed files (such as .zip files) cannot be used to upload data.

If you are importing sas7bat files, the amount of memory available for the reader is controlled by the JVM Heap Size setting on the corresponding Intelligence Server or MicroStrategy Webmachine.

  1. Open a new or existing dashboard.
  2. To import data into a new dataset, click Add Data and choose New Data.

    or

    To add data to a dataset, click the drop-down arrow next to the dataset name in the Datasets panel and choose Edit Dataset. The Preview Dialog opens. Click Add a New Table.

    The Data Sources dialog opens.

  3. Click File From Disk to import data from a file on your computer.

    The Upload Your Files dialog opens.

  4. Click Choose files. In the Choose File to Upload dialog, navigate to and select a file to import, and click Open. You can select multiple files.
  5. Click Prepare Data to preview, modify, and specify import options for your data.
  6. Click Finish. The data is imported into a new dataset or updated in an existing dataset.