> AI agents: this is one page from PostHog's docs. Full index of Markdown docs for LLMs: https://posthog.com/llms.txt

# Linking SharePoint as a source

**Alpha release**

This source is currently in **alpha**. The interface and available tables may change.

![](https://res.cloudinary.com/dmukukwp6/image/upload/texture_tan_9608fcca70)

![](https://res.cloudinary.com/dmukukwp6/image/upload/texture_tan_dark_a92b0e022d)

Let AI connect your sources for you

Skip the manual setup — run this in your project and the wizard auto-detects your databases and APIs and connects them to PostHog.

`npx @posthog/wizard warehouse`

![PostHog Wizard hedgehog](https://res.cloudinary.com/dmukukwp6/image/upload/wizard_3f8bb7a240.png)

![](https://res.cloudinary.com/dmukukwp6/image/upload/wizard_3f8bb7a240.png)Let AI connect your sources for you

The SharePoint connector syncs your SharePoint Online sites, lists, list items, document libraries, and file metadata into PostHog, so you can analyze your SharePoint data alongside your product data.

Personal OneDrive sites and hidden system lists are automatically excluded.

## Prerequisites

You need an [Entra ID (Azure AD) app registration](https://learn.microsoft.com/en-us/entra/identity-platform/quickstart-register-app) with a client secret. Grant it one of the following Microsoft Graph **application** permissions:

-   **Sites.Read.All** – syncs every SharePoint site in the tenant. Requires admin consent.
-   **Sites.Selected** – limits access to specific sites. List those site URLs in the **Site URLs** field during setup.

You'll also need the following values from your app registration:

-   Directory (tenant) ID
-   Application (client) ID
-   Client secret

## Adding a data source

1.  In PostHog, go to the [Sources tab](https://app.posthog.com/data-management/sources) of the data pipeline section.
2.  Click **\+ New source** and click **Link** next to this source.
3.  Enter your credentials (see [Configuration](#configuration) below) and click **Next**.
4.  Select the tables you want to sync, choose a sync method and frequency, then click **Import**.

Once the syncs are complete, you can start querying this data in PostHog.

When linking SharePoint, you'll need:

-   **Directory (tenant) ID** – the tenant ID from your Entra ID app registration, for example `00000000-0000-0000-0000-000000000000`.
-   **Application (client) ID** – the application (client) ID from your app registration.
-   **Client secret** – a client secret created for the app registration.
-   **Site URLs (optional)** – one URL per line to limit the sync to specific sites. Leave empty to sync every site the app can read. For example: `https://contoso.sharepoint.com/sites/marketing`.

## Sync modes

Each table can be synced in one of several modes, depending on what the source supports:

-   **Webhook** (when available) – the source pushes changes to PostHog in real time. Fastest freshness, lowest ongoing cost, and the only mode that reliably captures updates and deletes.
-   **Incremental** – only new or updated rows are synced on each run, using a cursor field (such as an `updated_at` timestamp). Cheaper than a full refresh, but deletes aren't captured.
-   **Append only** – new rows are appended using a cursor field; existing rows are never updated. Ideal for immutable, append-only tables like event logs.
-   **Full refresh** – the whole table is reloaded on every sync. Use it when a table has no reliable cursor or when you need deletions reflected.

See [sync methods](/docs/cdp/sources.md#sync-methods) for a full explanation of how each mode works and how to choose between them.

All SharePoint tables are full refresh. Each sync replaces the contents of the table. Microsoft Graph has no reliable "modified since" filter across lists and drives.

## Configuration

| Option | Description |
| --- | --- |
| `Directory (tenant) ID` **Type:** text **Required:** True |  |
| `Application (client) ID` **Type:** text **Required:** True |  |
| `Client secret` **Type:** password **Required:** True |  |
| `Site URLs (optional)` **Type:** textarea **Required:** False | One site URL per line. Leave empty to sync every site the app can read. |
| `Import CSV and Excel file contents?` **Type:** switch-group **Required:** False | Turn this on to create one table for each CSV file and each Excel worksheet in the document libraries of the sites above. Each sync reads the files in full. Excel files over 100 MB are skipped. Site URLs are required when this is on. |

## Supported tables

| Table | Description | Sync method | Incremental field | Primary key |
| --- | --- | --- | --- | --- |
| `sites` | SharePoint sites the app can read, excluding personal OneDrive sites | Full refresh | — | — |
| `lists` | Lists and document libraries in each site | Full refresh | — | — |
| `list_items` | Items in every visible list, with the list's column values in `fields` | Full refresh | — | — |
| `drives` | Document libraries (drives) in each site | Full refresh | — | — |
| `drive_items` | File and folder metadata in every document library | Full refresh | — | — |

Here's a summary of the tables the connector syncs:

| Table | Description |
| --- | --- |
| `sites` | SharePoint sites the app can read, excluding personal OneDrive sites |
| `lists` | Lists and document libraries in each site |
| `list_items` | Items in every visible list, with the list's column values in a `fields` JSON column |
| `drives` | Document libraries (drives) in each site |
| `drive_items` | File and folder metadata in every document library (not file contents) |

## Limitations

-   **File metadata only** – `drive_items` syncs file and folder metadata. It does not parse or import file contents (CSV, Excel, etc.).
-   **Personal OneDrive sites excluded** – the sync automatically skips personal OneDrive sites.
-   **Hidden system lists excluded** – SharePoint's internal system lists (workflow history, user info, etc.) are not synced.
-   **Full refresh only** – all tables use full refresh sync. Incremental sync is not available.

## Troubleshooting

-   If the connection fails with an Entra ID error, check the tenant ID, application (client) ID, and client secret are correct and that the secret has not expired.
-   If you see "Microsoft Graph denied access to SharePoint," grant the app the **Sites.Read.All** application permission with admin consent, or list the site URLs it was granted through **Sites.Selected**.
-   If a table syncs no rows, verify the app registration has access to the sites containing that data.

If your sync is failing or data looks wrong, see the [Data warehouse troubleshooting guide](/docs/data-warehouse/troubleshooting.md). If that doesn't help, [contact support](https://us.posthog.com/#panel=support%3Asupport%3Adata_warehouse%3A%3Atrue) – we're happy to help.

### Still have questions?

Ask PostHog AI

### Was this page useful?

HelpfulCould be better