MicroStrategy ONE

Import Data from a File Stored on Google Drive

You can import data from a file stored on Google Drive directly into Workstation. You can modify your file directly from your Google Drive folder, as with any other folder on your computer.

MicroStrategy does not store Google credentials.

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

  • .xlsx
  • .xls
  • .txt
  • .csv
  • .tsv
  • .prn
  • .json

  • .geojson

  • .kml

You must configure the OAuth parameters. You will need the Client ID and Client Secret that Google Drive provides when MicroStrategy Workstation is configured as a remote access application.

  1. Create a blank dashboard or open an existing one.

  2. Choose Add Data > New Data to import data into a new dataset.

    or

    In the Datasets panel, click More next to the dataset name and choose Edit Dataset to add data to the dataset. The Preview Dialog opens. Click Add a new table.

    The Data Sources dialog opens.

  1. Click Google Drive. At the prompts, sign into your Google account and allow MicroStrategy to access your Google Drive data. The Google Drive dialog opens with your Google Drive files and folders in the left pane.
  2. If necessary, expand folders to view the files in them.
  3. Drag the files you to want to import to the right pane.

  1. Click Prepare Data if you are adding a new dataset and want to preview, modify, and specify import options.

    or

    Click Add if you are editing an existing dataset.

  2. Click Finish if you are adding a new dataset.

    or

    Click Update Dataset if you are editing an existing dataset.

  3. View the new or updated datasets on the Datasets panel.

If an error occurs, click Yes to ignore the file with the error and continue.

or

Click No to display the file the with error. Fix the error and click Next.