---
title: "Microsoft OneDrive as a Source"
slug: "microsoft-onedrive-source"
description: "Securely integrate data from OneDrive with Dataddo's no-code platform. Sync your files and reports in real-time, ensuring seamless access and insights."
tags: ["Database as a source", "Custom-schema connector", "How-to guide", "Data source"]
updated: 2026-07-08T20:40:38Z
published: 2025-10-07T16:51:56Z
canonical: "docs.dataddo.com/microsoft-onedrive-source"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.dataddo.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Microsoft OneDrive as a Source

**Microsoft OneDrive** is a cloud-based storage service provided by Microsoft that allows users to store and access their files and documents from anywhere. It offers seamless integration with various devices and applications, enabling users to easily sync, share, and collaborate on their files while providing a secure and reliable storage solution.

## Authorize Connection to OneDrive

To authorize this service, use **OAuth 2.0** to share specific data with Dataddo while keeping usernames, passwords, and other information private.

1. On the **Authorizers** page, click on [Authorize New Service](https://app.dataddo.com/service/new) and select your service.
2. Follow the on-screen prompts to grant Dataddo the necessary permissions to **access and retrieve** your data.
3. **[Optional]** Once your ***authorizer*** is created, click on it to **change the label** for easier identification.

Ensure that the account you're granting access to holds at least **admin-level permissions**. If necessary, assign a team member with the required permissions with the [authorizer role](https://docs.dataddo.com/docs/user-roles#authorizer) to authenticate the service for you.

For more information, see our article on [***authorizers***](https://docs.dataddo.com/docs/authorized-services).

## How to Create a Microsoft OneDrive Data Source

1. On the **Sources** page, click on the [**Create Source**](https://app.dataddo.com/sources/new) button and select the connector from the list.
2. From the drop-down menu, select your ***authorizer***.
          **Didn't find your authorizer?**

          

Click on **Add new Account** at the bottom of the drop-down and follow the on-screen prompts. You can also go to the **Authorizers** tab and click on [**Add New Service**](https://app.dataddo.com/service/new).
3. **Name** your data source and fill in the following **optional** fields:
  1. **Drive ID**: After logging in to OneDrive, the ID is the string in the URL after `cid=`.
  2. **Path**: Select your directory, folder or input the name manually, e.g. `/Documents/`.

### Configure Your File

In the **File setup** step:

1. **Name** your file. You can apply dynamic file naming using predefined patterns. For more details, see [Dynamic File Naming Patterns](/docs/dynamic-file-naming-patterns).
2. Select your **File Format**. We support the following formats: `JSON`, `CSV`, `XML`, `XLXS`, `PARQUET`.
3. [Optional] You can choose to **compress** your file.
4. If you selected the `CSV` or `XLSX` file format, you can also configure the following additional settings:

| CSV Settings | Description |
| --- | --- |
| CSV Delimiter | Specifies the character used to separate values in the file. You can select from the following delimiters: comma `,`, semicolon `;`, or tab `\t`, or pipe `\|`. |
| Comment | [Optional] Lines starting with this character will be treated as comments and ignored during processing (e.g., `#`). |
| CSV Lazy Quotes | If enabled, allows fields with mismatched or unescaped quote characters to be parsed without error. Useful for handling imperfect CSVs. |
| CSV Header | If enabled, the first row of the file will be treated as the header row (column names). Disable this if your file does not include headers. |

| XLSX Settings | Description |
| --- | --- |
| Sheet | [Optional] Specifies the name of the worksheet within the Excel file where the data should be written. |
| Sheet Range | [Optional] Defines the cell range where data should be placed (e.g., `A1:D100`). Leave blank to use the full sheet automatically. |
| Sheet Header | If enabled, the first row in the sheet will be treated as a header (column names). Disable if the sheet should contain raw data only. |

### Finish Your Source Configuration

1. In the **Transformation** step, if needed, you can:
  1. Set the **Transformation engine** to be **MongoDB** or **JQ**.
  2. Then, manually edit the [transformation pipeline](/docs/transformation-pipeline) to fine-tune how your data is processed before reaching the destination.
2. Configure your [**sync frequency**](https://docs.dataddo.com/docs/extraction#extraction-frequency) or set the exact synchronization time under **Show advanced settings**.
3. Preview your data by clicking on the **Test Data** button in the top right corner. You can **adjust the date range** for a more specific time frame.
4. Click on **Save** and **congratulations, your new data source is ready!**

---

## Troubleshooting

### Data Preview Unavailable

No data preview when you click on **Test Data** might be caused by an issue with your ***source*** configuration. The most common causes are:

- **Date range**: Try a smaller date range. You can load the rest of your data afterward using [manual data load](https://docs.dataddo.com/docs/data-backfilling).
- **Insufficient permissions**: Please make sure your authorized account has at least admin-level permissions.
- **Invalid metrics, attributes, or breakdowns**: You may not have any data for the selected metrics, attributes, or breakdowns.
- **Incompatible combination of metrics, attributes, or breakdowns**: Your selected combination cannot be queried together. Please refer to the service's documentation to view a full list of metrics that can be included in the same ***data source***.

### Can't Find File

**ERROR MESSAGE** `itemNotFound - The resource could not be found.`

This issue might be caused by the following:

- **Empty or improper file path**: Make sure the field with file path is filled in. To find the file path, in your OneDrive, identity your file, click on the three dots and select **Details**. Scroll down to **Path** and copy everything after "My files".
  - E.g. If your path shows "My files > Documents > example.json", provide `/Documents/` as the file path.
- **Partial file name**: Make sure to **include** the file extension in the file name to locate it, e.g. `example.json` and not just `example`.

## Related Articles

Now that you have successfully created a ***data source***, see how you can connect your data to a dashboarding app or a data storage.

**Sending Data to Dashboarding Apps**

- [Simple Data Integration to Dashboards](https://docs.dataddo.com/docs/simple-data-integration-to-dashboards)
- [Data Backfilling to Dashboarding Apps](https://docs.dataddo.com/docs/data-backfilling-to-dashboarding-apps)

**Sending Data to Data Storages**

- [Batch Ingestion to Data Warehouses](https://docs.dataddo.com/docs/ingestion-to-data-warehouses)
- [Data Backfilling to Storages](https://docs.dataddo.com/docs/data-backfilling-to-storages)

**Other Resources**

- [Troubleshooting](https://docs.dataddo.com/docs/troubleshooting)
- [Extraction Logs](https://docs.dataddo.com/docs/extraction-logs)
- [Data Duplication](https://docs.dataddo.com/docs/data-duplication)

Authorizers act as credentials for external services (e.g. Facebook or Google). To enable Dataddo to access and retrieve your data, you need to grant access to accounts that possess admin-level permissions or higher within these services.