Do permissions and sharing links come along, or only the file metadata?

The Graph permissions endpoint exposes the role, the grantee and the link type for each item, and the sync lands those alongside the files. That's how the external-sharing audit and the sensitivity-versus-sharing reports work: they join the sharing role on a file to the sensitivity label and the recipient domain, instead of treating sharing as an opaque toggle in the admin centre.

OneDrive connector

Use your OneDrive data for reporting, automation and AI.

Data Panda brings your OneDrive files, sharing links and activity together with the data from the rest of Microsoft 365 and the systems around it. From one place, we turn your file storage into dashboards, automations, AI workflows and small apps your IT, compliance and operations teams use every day.

About OneDrive

The Microsoft 365 file layer that also catches every Teams attachment.

OneDrive started as Windows Live Folders in 2007, became SkyDrive later that year, and was renamed OneDrive in 2014 after a trademark dispute with British broadcaster BSkyB. Today it ships as part of Microsoft 365 in two distinct flavours: OneDrive (consumer, tied to a Microsoft account) and OneDrive for Business, which is a per-user SharePoint site under the hood. Tight Office integration, Teams chat-attachments that quietly save to the sender's OneDrive, and Outlook attachments that can be sent as OneDrive links make it the default file layer for most Microsoft-stack tenants.

What makes OneDrive interesting to report on is exactly what makes it slippery to govern by hand. The Microsoft Graph API exposes drives, items, permissions, sharing links, versions and activity, and on a real tenant that surface is enormous. The admin centre shows quota and a per-user activity report. The harder questions, like which OneDrive accounts belong to leavers and still hold the only copy of an important deck, how external sharing has grown since the last Teams guest wave, or which files are duplicated across OneDrive and a SharePoint team site, sit between OneDrive, Microsoft 365 audit logs and Entra ID. Pulling OneDrive into a warehouse is how IT and compliance answer those questions on a schedule instead of hunting through the Graph one user at a time.

What your OneDrive data is for

What you get once OneDrive is connected.

Storage and sharing reporting

Quota usage, external-sharing footprint and orphaned-file inventory across the OneDrive estate.

Per-user quota and growth trend, with the largest folders and the share that comes from Teams attachments
External sharing links per account, ranked by recipient domain and last-access age
Leaver inventory: OneDrive accounts of departed users with files that have no other internal owner

File and offboarding automation

Let OneDrive activity drive the rest of your Microsoft 365 stack, without IT chasing every leaver by hand.

Leavers in Entra ID trigger a OneDrive content-handover flow to the manager, with the file inventory attached
External sharing links to non-allow-listed domains open a review task in the right governance queue
Closed-won deals in the CRM auto-create the customer folder in the right SharePoint or OneDrive location with the agreed permissions

AI workflows

Put your real OneDrive content behind AI that respects the permission model, instead of a generic assistant.

Internal search grounded in the OneDrive and SharePoint files a user is allowed to see, with source links back to the original
Auto-classification of newly uploaded documents against your existing sensitivity labels
Summarisation of long proposals or reports queued into the right reviewer's task list

Custom apps on your data

Small tools that sit on OneDrive data for people who do not live in the Microsoft 365 admin centre.

Quota and cleanup app per team, showing the biggest stale folders and the Teams attachments behind them
External-share review app with an action queue for the file owner, not for IT
Leaver handover app that walks a manager through the departed user's OneDrive content one bucket at a time

Use cases

Use cases we deliver with OneDrive data.

A list of concrete reports, automations and AI features we have built on OneDrive data. Pick the one that matches your situation.

Quota and growth trackingPer-user storage and growth trend, with the biggest folders and the Teams-attachment share called out.

External sharing auditSharing links per account, ranked by recipient domain, link type and last-access age.

Leaver content inventoryDeparted users in Entra ID matched to their OneDrive content, with the files no other person owns flagged.

OneDrive vs SharePoint duplicationFiles stored in a personal OneDrive that also exist on a SharePoint team site, by team and modified date.

Teams-attachment buildupVolume that landed in OneDrive through Teams chat, by sender and channel, with the stale share called out.

Stale shared linksExternal and internal sharing links untouched for N months, by file owner and link type.

Sensitivity vs sharingFiles labelled confidential that have an active external sharing link, by owner and recipient domain.

Bin-recovery patternsFiles restored from the OneDrive recycle bin, by user and time-since-delete, to spot accidental wipes early.

Office co-authoring activityDocuments with multiple editors over time, joined to the project or deal record they belong to.

Sync-client error trendsOneDrive sync errors per device, surfaced for IT before the user opens a ticket.

Real business questions

Answers you will finally get.

How much of our OneDrive volume is Teams chat attachments?

Per user the share of stored volume that landed via Teams chat, broken down by sender, channel and last-access age. Surfaces the long tail of one-screenshot-pasted-into-a-DM files that quietly fill quotas, before IT starts buying extra storage to paper over it.

Which leavers still have OneDrive files no one else owns?

Departed users in Entra ID joined to their OneDrive inventory, with files filtered to the ones that have no other internal editor or shared location. The manager gets a real handover list per leaver instead of a 30-day reminder that the account is about to expire.

Where is OneDrive duplicating what already lives on SharePoint?

Files present in a personal OneDrive that also exist on a SharePoint team site, matched on hash and name, with the modified-date gap shown. The drift between the working copy on OneDrive and the canonical copy on SharePoint becomes a list IT can act on, instead of a hunch.

Value for everyone in the organisation

Where each function gets value.

For finance leaders

Contract folders, signed quotes and audit-relevant documents reportable next to the deal record. Finance sees which contracts are missing the signed PDF or the renewal addendum, instead of opening OneDrive folders one by one before period close.

For sales leaders

Customer-facing collateral and proposals stored in OneDrive joined to the CRM account. Sales sees which prospects opened the proposal, how often, and which collaborators on their side engaged with the file.

For operations

A tenant-wide view on quota, external sharing and offboarding gaps. Ops runs a quarterly OneDrive cleanup with a real list per team owner instead of asking everyone to do their own audit.

Ideas

What you can automate with OneDrive.

Pair with Microsoft Teams

Track Teams chat attachments back to their OneDrive owner

Files shared in Microsoft Teams chat are saved to the sender's OneDrive by default, and that quietly accounts for a big share of personal storage. The pairing joins Teams messages to the OneDrive item ID behind the attachment, so IT sees per channel and per sender how much storage gets consumed by chat-pasted files and which of those files nobody opened past the day they landed.

Pair with Salesforce

Wire Salesforce Files through to OneDrive

Files attached to a Salesforce account, opportunity or case land in the matching OneDrive or SharePoint folder, and the OneDrive item ID is written back on the Salesforce record. Sales reps stop maintaining a parallel Files attachment for the deck they already store in OneDrive, and the next person on the account opens the latest version from either side without guessing where it lives.

Pair with HubSpot

Link OneDrive sales collateral to the HubSpot deal

Proposals, contracts and onboarding documents in OneDrive are linked to the matching HubSpot deal and contact, with last-modified and last-opened metadata kept in sync. Sales sees which prospects opened the proposal and which collaborators on the buyer side engaged with it, instead of guessing from a generic email open rate.

Pair with Slack

Post OneDrive file activity to the right Slack channel

Uploads, new external shares and permission changes on flagged OneDrive folders post a compact update in the Slack channel that owns the topic, with a link back to the file in OneDrive. Account teams stop relying on someone watching a folder, and a lightweight audit trail sits next to the conversation where it matters.

Your existing tools

Your data lands in a warehouse. Your BI tools read from it.

You keep the reporting tool you already have. We connect it to the warehouse where your OneDrive data lives.

Power BI Microsoft

Fabric Microsoft

Snowflake Data warehouse

BigQuery Google

Tableau Visualisation

Excel Sheets & pivots

Three steps

From OneDrive to answers in three steps.

Connect securely

OAuth authentication. Read-only by default. We sign a DPA and your admin keeps the keys.

Land in your warehouse

Data flows into your warehouse on your schedule. Near real time or nightly, your call. You own the data.

Reporting, automation, AI

We build the first dashboard, workflow or AI feature with you, then hand over the keys. Or we stay on for ongoing delivery.

Two ways to work with us

Pick the track that fits how you work.

Track 01

Self-serve

We set up the foundation. Your team builds on top.

OneDrive connector configured and running
Warehouse set up in your cloud account
Clean access for your Power BI, Fabric or Tableau team
Documentation on what's in the data model
Sync monitoring so you're warned before reports break

Best fit Teams that already have a BI analyst or data engineer and want to own the build.

Track 02

Done for you

We build the whole thing, end to end.

Everything in Self-serve
Dashboards built to the questions your team actually asks
Automations between your systems
AI workflows scoped to real tasks your team runs
Custom apps where a dashboard does not cut it
Ongoing delivery at a pace that fits your team

Best fit Teams without in-house BI or dev capacity. You tell us what you need and we deliver it.

Before you book

Frequently asked questions.

Who owns the data?

You do. It lands in your warehouse, on your cloud account. We don't resell or aggregate it. If you stop working with us, the warehouse stays yours and keeps running.

How fresh is the data?

Near real time for most operational systems. For heavier sources we schedule hourly or nightly. You pick based on what the reports need.

Do I need a warehouse already?

No. If you don't have one, we help you pick one and set it up as part of the first delivery. Common starting points are Snowflake, Microsoft Fabric, or a small Postgres start.

Does the sync cover OneDrive only, or also the SharePoint sites behind it?

OneDrive for Business is a SharePoint site per user under the hood, and Teams team-files live on a SharePoint site too. The sync uses Microsoft Graph drives and items, so personal OneDrive content, Teams files and SharePoint document libraries land on the same shape. That's what makes the OneDrive-versus-SharePoint duplication and Teams-attachment reports possible: they all join on the same item identifiers.

Will the sync run into Microsoft Graph throttling on a big tenant?

The Graph API throttles per app and per user, and OneDrive endpoints have their own limits on top. We use delta queries on drives so subsequent syncs only pull what changed, paginate item traversal carefully, and back off on 429 responses, so a tenant with thousands of users keeps syncing without burning the Graph quota that Copilot, Power Automate and your other Microsoft 365 integrations also depend on.

GDPR-compliant

Data stays in the EU

You own the warehouse

A first deliverable live in four to six weeks.

We review your OneDrive setup and the systems around it. Together we pick the first thing worth building.

Book a call See our other connectors