Links about SharePoint on Microsoft Graph Data Connect

Introduction

Microsoft Graph Data Connect delivers rich data assets to OneDrive and SharePoint tenants, so they can run their own analytics, derive insights from their data and understand how they use these products. The data is transferred to an Azure account owned by the tenant, where they can use tools like Azure Synapse and Power BI to transform this into insightful reports and dashboards.

The two main scenarios are Security (information oversharing, external sharing) and Capacity (understanding site lifecycle and storage). SharePoint currently offers 3 datasets via Data Connect: Sites, Groups and Sharing. This solution is available as a private preview in 9 regions (APC, AUS, BRA, CAN, EUR, FRA, JPN, GBR, NAM).

This blog post is a collection of links related to the OneDrive and SharePoint data available via Data Connect. This is meant as pointers to specific and relevant content, which you can bookmark for future reference.

Data Connect main links

• Data Connect main link – Microsoft Graph Data Connect
  
• Video: Microsoft Graph Data Connect at Microsoft Mechanics – YouTube
  
• Video: Microsoft Graph Data Connect with SharePoint Demo – YouTube
  Part of the Microsoft 365 Community Call on 2022-11-28

SharePoint Schemas

• DocumentSharingDataset_v0_Preview – SharePoint Sharing Permissions
  https://github.com/microsoftgraph/dataconnect-solutions/blob/main/datasetschemas/DocumentSharingDataset_v0_Preview.md
  
• SharePointGroupsDataset_v0_Preview – SharePoint Groups
  https://github.com/microsoftgraph/dataconnect-solutions/blob/main/datasetschemas/SharePointGroupsDataset_v0_Preview.md
  
• SharePointSitesDataset_v0_Preview – SharePoint Sites
  https://github.com/microsoftgraph/dataconnect-solutions/blob/main/datasetschemas/SharePointSitesDataset_v0_Preview.md

Step-by-step guides

• Step-by-step: Gathering a detailed dataset on your SharePoint Sites
  https://barreto.home.blog/2022/10/17/gathering-a-detailed-dataset-on-your-sharepoint-sites/

• Information Oversharing Template Setup
  https://go.microsoft.com/fwlink/?linkid=2207816 (follow the instructions)
  
• Power BI sample with that you can use with the data coming from the pipeline
  https://go.microsoft.com/fwlink/?linkid=2211101 (click on the download button)

• Four Options for SharePoint Site Analytics
  https://barreto.home.blog/2022/11/01/four-options-for-sharepoint-site-analytics/
  
• Microsoft Graph Data Connect step-by-step with Azure Data Factory by Nik Charlebois
  https://nikcharlebois.com/getting-started-with-microsoft-graph-data-connect-mgdc/
  
• Summary of the M365 Community Call on 2022-11-29 with a demo of SharePoint with Data Connect
  https://warner.digital/m365platformsummary11292022/

Frequently Asked Questions (blog series)

• SharePoint on Data Connect FAQ: Which date should I query?
• SharePoint on Data Connect FAQ: How can I use Delta State Datasets?
• SharePoint on Data Connect FAQ: Which regions are supported?
• SharePoint on Data Connect FAQ: What counts as an object?
• SharePoint on Data Connect FAQ: How do I process Deltas?
• SharePoint on Data Connect FAQ: Is OneDrive included?

Other Blogs about SharePoint on Data Connect

• Ignite 2022: Transforming collaboration with low and pro code dev tools – Microsoft 365 Developer Blog (search for “SharePoint datasets”)
  
• Scale access to Microsoft 365 data with Microsoft Graph Data Connect – Microsoft 365 Developer Blog (search for “SharePoint”)
  
• Unlimited collaboration insights with Microsoft Graph and Azure Synapse Analytics – Microsoft Mechanics Blogs (covers Data Connect with Synapse in General, includes video)

Presentations

• Microsoft 365 Conference 2023
  Understand Information Oversharing and Site Lifecycle using SharePoint Data
  (Talk delivered on May 4, 2023 at 11:45AM)
  
• Build 2022
  Unlocking the power of your Microsoft 365 data with Microsoft Graph Data Connect | OD09
  (Good overview of Data Connect, with SharePoint datasets mentioned at minute 5:08)
  
• Ignite 2022
  Graham Sheldon: From low code to pro code: building and buying collaborative apps to power an evolving workplace
  (Synapse template described at minute 26:25)
  
• Ignite 2022
  Rohan Kumar: Innovate faster and achieve greater agility with the Microsoft Intelligent Data Platform
  (Data Connect and analytics with Synapse mentioned at minute 16:52)
  
• Microsoft Mechanics
  Unlimited collaboration insights with Microsoft Graph & Azure Synapse Analytics
  
• Microsoft 365 Community Call
  Microsoft 365 Platform Community Call – 29th of November, 2022
  (Includes Data Connect Overview and Demo)
  

Other links

• Main Data Connect documentation link: https://aka.ms/mgdcdocs
  
• All Data Connect datasets – https://learn.microsoft.com/en-us/graph/data-connect-datasets
  
• Data Connect billing – https://learn.microsoft.com/en-us/graph/data-connect-policies
  
• Data Connect Integration with the Privileged Access Management (PAM) – https://learn.microsoft.com/en-us/graph/data-connect-pam
  
• Video: Microsoft Graph Data Connect Overview (includes demo) – YouTube

Let me know if you have other links that you would like to add to this list…