Copilot is so good at manipulating data
One of the less known capabilities in Copilot is the ability to transform text in lists. I recently had to transform a list of companies from one format to another. It’s one of those things that I used to do with Word or Excel, like sorting, removing a number from the beginning of a line…
Microsoft Graph Data Connect for SharePoint – Oversharing for Very Large Tenants
IMPORTANT NOTE: This blog post is no longer current. Please visit the latest version of this blog in the official Microsoft Graph Data Connect for SharePoint blog in the Tech Community web site. 0. Introduction If you have a large SharePoint tenant (with hundreds of thousands of sites), you might run into some issues while trying…
Counting Microsoft Entra ID (Azure Active Directory) Groups
Groups and Permissions If you use Microsoft Graph Data Connect for SharePoint, you know that the datasets from SharePoint will give detailed permissions, including which users have access to sites, libraries, folders and files. However, permissions are frequently granted to Microsoft Entra ID (new name for Azure Active Directory) groups. To fully understand how many…
MGDC for SharePoint – Updated on 11/2023
I would like to share some exciting news for the Microsoft Graph Data Connect for SharePoint (Project Archimedes). First, we published updated schema documents for our 3 existing datasets. These new docs include more details like scenarios, questions the dataset answers and how it can be joined to other datasets, in addition to the traditional…
Microsoft Graph Data Connect for SharePoint FAQ: How can I estimate my Azure bill?
IMPORTANT NOTE: This blog post is no longer current. Please visit the latest version of this blog in the official Microsoft Graph Data Connect for SharePoint blog in the Tech Community web site. Introduction When gathering SharePoint data through Microsoft Graph Data Connect, you are billed through Azure. As I write this blog, the price to…
MGDC for SharePoint – Overview and prerequisites
You can use the Microsoft Graph Data Connect for SharePoint to extract SharePoint and OneDrive information and use that to run analytics for your tenant. You get data in an Azure Storage account owned by the tenant, and you can easily transform and visualize the data. For example, if you’re looking at the SharePoint Sites…
MGDC for SharePoint – Update on 08/2023
0. Overview There have been a lot of changes in Microsoft Graph Data Connect for SharePoint (a.k.a. Project Archimedes) recently. Let’s take a moment to review these key changes, which can be grouped into three main categories: the public preview phase, enhancements to the setup process, and the introduction of new documentation. 1. Public Preview…
Step-by-step: Gathering a detailed dataset on your SharePoint Sites (New Consent)
A step-by-step guide to getting SharePoint Sites information using the Microsoft Graph Data Connect, Azure Synapse and Power BI IMPORTANT NOTE: This blog post is no longer current. Please visit the latest version of this blog in the official Microsoft Graph Data Connect for SharePoint blog in the Tech Community web site. IMPORTANT NOTE: This…
SharePoint on MGDC FAQ: What is the size of my sites?
IMPORTANT NOTE: This blog post is no longer current. Please visit the latest version of this blog in the official Microsoft Graph Data Connect for SharePoint blog in the Tech Community web site. 1. Introduction How much storage is being used by your SharePoint sites? Sounds like a simple question, but there are lots of details…
Improving Your Writing with the Help of Bing Chat or ChatGPT
I have been experimenting with Bing Chat and am always amazed by its ability to enhance my writing. By prompting it to rewrite my work and specifying a desired style or tone, I have found that it produces truly exceptional results. Here are a few examples. Me: Rewrite this: Title: Using Bing Chat or ChatGPT…
SharePoint on MGDC FAQ: What is in the Permissions dataset?
IMPORTANT NOTE: This blog post is no longer current. Please visit the latest version of this blog in the official Microsoft Graph Data Connect for SharePoint blog in the Tech Community web site. 1. Introduction With the Sharing Permissions dataset in Microsoft Graph Data Connect, you can see all the SharePoint permissions in your tenant. This…
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. The video shows how to check the required pre-requisites in Microsoft 365 and Azure, how to trigger the pipeline from Azure Synapse, and how to show the data in a…
9 regions now available for SharePoint Data via Microsoft Graph Data Connect
IMPORTANT NOTE: This blog post is no longer current. Please visit the latest version of this blog in the official Microsoft Graph Data Connect for SharePoint blog in the Tech Community web site. This is a quick blog to share that the SharePoint datasets in Microsoft Graph Data Connect are now available in 9 regions, up…
SharePoint on MGDC FAQ: Is OneDrive included?
IMPORTANT NOTE: This blog post is no longer current. Please visit the latest version of this blog in the official Microsoft Graph Data Connect for SharePoint blog in the Tech Community web site. 1. SharePoint datasets and OneDrive When I describe the SharePoint datasets in Microsoft Graph Data Connect (MGDC) to someone, I frequently get this…
SharePoint on MGDC FAQ: How do I process Deltas?
IMPORTANT NOTE: This blog post is no longer current. Please visit the latest version of this blog in the official Microsoft Graph Data Connect for SharePoint blog in the Tech Community web site. This is a follow up on the two blogs about delta datasets. If you haven’t read them yet, take a look: Our team…
SharePoint on MGDC FAQ: What counts as an object?
IMPORTANT NOTE: This blog post is no longer current. Please visit the latest version of this blog in the official Microsoft Graph Data Connect for SharePoint blog in the Tech Community web site. 1. Overview When gathering SharePoint data through Microsoft Graph Data Connect (MGDC), you are billed through Azure. You can find the official MGDC…
Links about Microsoft Graph Data Connect for SharePoint
IMPORTANT NOTE: This blog post is no longer current. Please visit the latest version of this blog in the official Microsoft Graph Data Connect for SharePoint blog in the Tech Community web site. Introduction Microsoft Graph Data Connect for SharePoint delivers rich data assets to OneDrive and SharePoint tenants, so they can run their own…
SharePoint on MGDC FAQ: Which regions are supported?
IMPORTANT NOTE: This blog post is no longer current. Please visit the latest version of this blog in the official Microsoft Graph Data Connect for SharePoint blog in the Tech Community web site. 1. Overview When gathering SharePoint data through Microsoft Graph Data Connect (MGDC), you need to pay attention to an important detail: regions. That…
Asking ChatGPT and the new Bing for help with merging a Delta dataset (SharePoint Data on MGDC)
IMPORTANT NOTE: This blog post is no longer current. Please visit the latest version of this blog in the official Microsoft Graph Data Connect for SharePoint blog in the Tech Community web site. I was considering if ChatGPT could help me write SQL code to merge a SharePoint Delta State Dataset, like the ones we are…
SharePoint on MGDC FAQ: How can I use Delta State Datasets?
IMPORTANT NOTE: This blog post is no longer current. Please visit the latest version of this blog in the official Microsoft Graph Data Connect for SharePoint blog in the Tech Community web site. 1. Overview When gathering SharePoint data through Microsoft Graph Data Connect in a large tenant, you might be pulling many thousands or even…
Jose Barreto's Blog 