This post has been republished via RSS; it originally appeared at: New blog articles in Microsoft Community Hub.
Introduction
Microsoft Graph Data Connect for SharePoint 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 Microsoft Graph Data Connect: Sites, Groups and Permissions. This solution is available as a public preview in 15 Microsoft 365 regions.
Security Scenario
The Security Scenario focuses on understanding the permissions in your SharePoint and OneDrive tenant. By looking at the Sites, Permissions and Groups datasets, you can understand if your content is properly protected.
Here are a few common questions that you will be able to answer:
- Is oversharing happening?
- Is external sharing happening?
- Is sensitive data being shared?
- Howe much sharing per sensitivity label?
- Is sensitive data shared with external users?
- What external domains are being shared with?
- Which sites have been shared the most?
- What roles (levels of sharing) are being used?
- What permissions does a specific user have?
- What file extensions are most shared?
- How much sharing happens at the Web, Folder, List or File level?
- A combination of any of the questions above…
Capacity Scenario
The Capacity Scenario focuses on understanding site lifecycle, ownership and storage used by your SharePoint sites and OneDrives. By looking at the Sites and Groups, you can understand hour much content you have, how it is being used.
Here are a few common questions that you will be able to answer:
- What SharePoint sites are the largest?
- What type of site uses the most storage?
- What’s the current storage for sensitive sites?
- How much is used by previous versions?
- Which sites were updated in the last few months?
- Which sites have just one owner?
- How many sites were created over 2 years ago?
- How many sites haven’t changed in 1 year?
- How many sites have over 1TB of files?
- A combination of any of the questions above…
Links to resources
Here are some useful links related to the OneDrive and SharePoint data available via Microsoft Graph Data Connect. This is meant as a convenient set of pointers to specific and relevant content, which you can bookmark for future reference.
Step-by-step guides
- Step-by-step: Gathering a detailed dataset on your SharePoint Sites
- https://barreto.home.blog/2023/08/22/step-by-step-gathering-a-detailed-dataset-on-your-sharepoint-sites-new-consent/
- 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)
- Demo: Microsoft Graph Data Connect for SharePoint Demo
https://www.youtube.com/watch?v=hdPKM835ICY
SharePoint Datasets and Schemas
- Dataset description: SharePoint Sites
Dataset name: BasicDataSet_v0.SharePointSites_v1
Link to dataset schema: https://github.com/microsoftgraph/dataconnect-solutions/blob/main/Datasets/data-connect-dataset-sharepointsites.md
Dataset old (deprecated) name: SharePointSitesDataset_v0_Preview - Dataset description: SharePoint Groups
Dataset name: BasicDataSet_v0.SharePointGroups_v1
Link to dataset schema: https://github.com/microsoftgraph/dataconnect-solutions/blob/main/Datasets/data-connect-dataset-sharepointgroups.md
Old dataset (deprecated) name: SharePointGroupsDataset_v0_Preview - Dataset description: SharePoint Sharing Permissions
Dataset name: BasicDataSet_v0.SharePointPermissions_v1
Link to dataset schema: https://github.com/microsoftgraph/dataconnect-solutions/blob/main/Datasets/data-connect-dataset-sharepointpermissions.md
Old dataset (deprecated) name: DocumentSharingDataset_v0_Preview
You can see the official list of datasets at https://aka.ms/SharePointDatasets
Frequently Asked Questions
Links to the Microsoft Graph Data Connect for SharePoint FAQ blog series:
- Which date should I query?
- How can I use Delta State Datasets?
- Which regions are supported?
- What counts as an object?
- How do I process Deltas?
- Is OneDrive included?
- What is in the Permissions dataset?
- What is the size of my sites?
- How can I estimate my Azure bill?
Microsoft Graph Data Connect for SharePoint – Official Announcements
- Official blog post announcing new SharePoint datasets – Blog
- Official blog post announcing the public preview and dataset renames – Blog
- Official blog post announcing the pricing update for SharePoint datasets – Blog
Microsoft Graph Data Connect main links
- Microsoft Graph Data Connect main link – Microsoft Graph Data Connect
- All Microsoft Graph Data Connect datasets – https://learn.microsoft.com/en-us/graph/data-connect-datasets
- Microsoft Graph Data Connect billing – https://learn.microsoft.com/en-us/graph/data-connect-policies
- Video: Microsoft Graph Data Connect Overview (includes demo) – YouTube
- 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
Other Blogs about SharePoint on Data Connect
- Four Options for SharePoint Site Analytics
https://barreto.home.blog/2022/11/01/four-options-for-sharepoint-site-analytics/ - 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
- 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)