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?
Author: joseabarreto
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 … Continue reading Links about SharePoint on MGDC
SharePoint on MGDC FAQ: Which regions are supported?
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 Microsoft 365 tenant (the data source) and the region of the Azure Storage account (the data destination). In this blog, we’ll investigate the importance of understanding … 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 (MGDC) 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 … 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?
Four Options for SharePoint Site Analytics
Overview Here's a scenario: imagine that you are a SharePoint Online administrator and you have been asked to provide analytics about how the company is leveraging these resources. You want to understand: How many sites of each type do we have and how much storage do they use? How many sites have no new content … Continue reading Four Options for SharePoint Site Analytics
Loading CSV/text files with more than a million rows into Excel
1. The Problem If you usually load a very large CSV (comma-separated values) file or text file into Excel, you might run into the dreaded "File not loaded completely" message: As the message explains, the file you are trying to load is too large for Excel to handle. For me, it typically happens with large … Continue reading Loading CSV/text files with more than a million rows into Excel
Broken image link? Search the archive…
I blogged for 15 years using the old TechNet blogs sites, under the https://blogs.technet.com/josebda URL. As you can tell if you click on that old link, it's no longer there. That blog service was closed, but there is an archive at https://learn.microsoft.com/en-us/archive/blogs/josebda/ including all the hundreds of posts from 2004 to 2018. I also backed … Continue reading Broken image link? Search the archive…
Scary SQL Server stuff: tombstones, phantoms, ghosts and zombies
This post mixes the spirit of Halloween and the passion for SQL Server 🙂 Have you noticed how SQL Server has a number of things that seem right out of a horror movie? As a test of your SQL Server expertise and for a fun Halloween trivia game, try to describe the items in … Continue reading Scary SQL Server stuff: tombstones, phantoms, ghosts and zombies
Jose Barreto's Blog 