Links about SharePoint on MGDC

Introduction

Microsoft Graph Data Connect (MGDC) 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 MGDC: Sites, Groups and Sharing. This solution is available as a private preview in 5 regions (APC, AUS, EUR, GBR, NAM).

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

MGDC main links

• MGDC 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

• 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 (MGDC) 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 MGDC
  https://warner.digital/m365platformsummary11292022/

Frequently Asked Questions (blog series)

• SharePoint on MGDC FAQ: Which date should I query?
• SharePoint on MGDC FAQ: How can I use Delta State Datasets?
• SharePoint on MGDC FAQ: Which regions are supported?
• SharePoint on MGDC FAQ: What counts as an object?

Other Blogs about SharePoint on MGDC

• 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 MGDC with Synapse in General, includes video)

Presentations

• Build 2022
  Unlocking the power of your Microsoft 365 data with Microsoft Graph Data Connect | OD09
  (Good overview of MGDC, 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
  (MGDC 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 MGDC Overview and Demo)
  

Other links

• Main MGDC documentation link: https://aka.ms/mgdcdocs
  
• All MGDC datasets – https://learn.microsoft.com/en-us/graph/data-connect-datasets
  
• MGDC billing – https://learn.microsoft.com/en-us/graph/data-connect-policies
  
• MGDC 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…