Microsoft Graph Data Connect for SharePoint – M365 Conference Demo

For those that could not attend the recent Microsoft 365 conference, I have a demo of the Microsoft Graph Data Connect for SharePoint at: https://www.youtube.com/watch?v=hdPKM835ICY. M365 Demo on Microsoft Graph Data Connect for SharePoint The video shows how to check the required pre-requisites in Microsoft 365 and Azure, how to trigger the pipeline from Azure … Continue reading Microsoft Graph Data Connect for SharePoint – M365 Conference Demo

9 regions now available for SharePoint Data via Microsoft Graph Data Connect

This is a quick blog to share that the SharePoint datasets in Microsoft Graph Data Connect are now available in 9 regions, up from 5 regions previously. Here’s the updated list: Office regionAzure regionsAsia-PacificEast AsiaSoutheast AsiaAustraliaAustralia EastAustralia SoutheastBrazilBrazil SouthBrazil SoutheastCanadaCanada CentralCanada EastEuropeNorth EuropeWest EuropeFranceFrance CentralJapanJapan EastJapan WestNorth AmericaCentral USEast USEast US 2North Central USSouth Central … Continue reading 9 regions now available for SharePoint Data via Microsoft Graph Data Connect

SharePoint on MGDC FAQ: Is OneDrive included?

1. SharePoint datasets and OneDrive When I describe the SharePoint datasets in Microsoft Graph Data Connect (MGDC) to someone, I frequently get this question: do Sites and Sharing cover only SharePoint or do they include OneDrive? The short answer is that OneDrive is included, but there is much more to say here… 2. OneDrive is … Continue reading SharePoint on MGDC FAQ: Is OneDrive included?

SharePoint on MGDC FAQ: How do I process Deltas?

This is a follow up on the two blogs about delta datasets. If you haven't read them yet, take a look: SharePoint on MGDC FAQ: How can I use Delta State Datasets? Asking ChatGPT and the new Bing for help with merging a Delta dataset (SharePoint Data on MGDC) Our team got some follow-up questions on this, … Continue reading SharePoint on MGDC FAQ: How do I process Deltas?

SharePoint on MGDC FAQ: What counts as an object?

1. Overview When gathering SharePoint data through Microsoft Graph Data Connect (MGDC), you are billed through Azure. You can find the official MGDC pricing information at Pricing - Microsoft Graph Data Connect. As I write this blog, the price to pull 1,000 objects from MGDC in the US is $0.375. Since the MGDC basic rate … Continue reading SharePoint on MGDC FAQ: What counts as an object?

Featured

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 … Continue reading Links about SharePoint on Microsoft Graph Data Connect

SharePoint on MGDC FAQ: Which regions are supported?

Important P.S.: Since the publication of this blog, SharePoint Data in MGDC was expanded from 5 regions to 9 regions. Read more about them at https://barreto.home.blog/2023/05/07/9-regions-now-available-for-sharepoint-data-via-mgdc/ 1. Overview When gathering SharePoint data through Microsoft Graph Data Connect (MGDC), you need to pay attention to an important detail: regions. That includes both the region of your … Continue reading SharePoint on MGDC FAQ: Which regions are supported?

Asking ChatGPT and the new Bing for help with merging a Delta dataset (SharePoint Data on MGDC)

I was considering if ChatGPT could help me write SQL code to merge a SharePoint Delta State Dataset, like the ones we are now offering using the Microsoft Graph Data Connect (MGDC). If you're new to the scenario, you can read about it at this blog post: SharePoint on MGDC FAQ: How can I use … Continue reading Asking ChatGPT and the new Bing for help with merging a Delta dataset (SharePoint Data on MGDC)

SharePoint on MGDC FAQ: How can I use Delta State Datasets?

1. Overview When gathering SharePoint data through Microsoft Graph Data Connect in a large tenant, you might be pulling many thousands or even millions of objects. If you want to always have the latest information available, you will likely run your pipeline daily. In this blog, we’ll investigate how you can use what we call … Continue reading SharePoint on MGDC FAQ: How can I use Delta State Datasets?

SharePoint on MGDC FAQ: Which date should I query?

1. Filter by SnapShotDate When gathering SharePoint data through Microsoft Graph Data Connect (MGDC), you must choose the date to query. This is expressed as a required filter on the SnapshotDate column (see picture below for an example using the Synapse Copy Data tool). You typically want the "Start time" and "End time" to be … Continue reading SharePoint on MGDC FAQ: Which date should I query?