How to Connect to OneDrive as a Data Source

OneDrive is a Microsoft cloud service that allows you to securely store, share, and access your files from anywhere. OneDrive for Business is the online content sync and storage service that comes with Office 365 and SharePoint Server.

Use MicroStrategy OneDrive connector to import data from supported files in Microsoft OneDrive and OneDrive for Business accounts directly into the MicroStrategy platform.

Features

  • Secure OAuth 2.0 authorization through Microsoft to access a user’s files without storing their account credentials
  • Ability to import the following file types:
    • .xls
    • .xlsx
    • .txt
    • .csv
    • .json
  • Select and import multiple files
  • Manual cube republish (with re-authentication, if necessary)
  • Support for MicroStrategy Web, Workstation, and Desktop 11.0 or later

MicroStrategy Web, Workstation, or Desktop 11.0 or later

A valid OneDrive or OneDrive for Business account containing the supported files you would like to import

Using the OneDrive Connector to Import Data

  1. Choose Add Data > New Data. The Data Sources dialog opens.
  2. Find the OneDrive connector from the data source list.

  3. Click the connector.
  4. Log in to your OneDrive or OneDrive for Business account.

  5. Click Yes.

    If logging in to a OneDrive for Business account, you may be redirected to your organization’s sign-in page to log in and accept the connector app permissions.

  6. Upon successful connection, you are redirected to a data import page where you can see all objects in your OneDrive or OneDrive for Business account.

  7. Identify the objects to import. Double-click the objects or drag and drop them in Selected Tables.

    Drag and drop is available on all platforms except Windows Workstation and Windows Desktop.

  8. Click Submit.

    Depending on the datasets selected, this process may take some time

    For Excel files with multiple sheets, select which sheets to include in the final dataset.

     

  9. On the Preview dialog, wrangle your data and click Finish.

Did you find this helpful?
Waren Ihnen die Informationen hilfreich?
Ces informations vous ont-elles été utiles ?
Questo contenuto ti è stato utile?
¿Le ha resultado útil?
Você achou isso útil?
役に立ちましたか?
도움이 되었습니까?
您觉得这篇文章有用吗?