Jose Barreto
@josebarreto.bsky.social
Jose Barreto is a Principal PM Architect in the E+D Division at Microsoft, focusing on SharePoint and OneDrive. These are my personal opinions.
I got a question today about using MGDC for SharePoint with Microsoft Fabric. One of the best examples is the Capacity Template v2 for Microsoft Fabric. Check out the blog with lots of screenshots...
techcommunity.microsoft.com/blog/microso...
techcommunity.microsoft.com/blog/microso...
Capacity Template v2 with Microsoft Fabric | Microsoft Community Hub
1. Capacity Scenario
One of the most common scenarios for Microsoft Graph Data Connect (MGDC) for SharePoint is Capacity. This scenario focuses...
techcommunity.microsoft.com
October 9, 2025 at 3:47 PM
I got a question today about using MGDC for SharePoint with Microsoft Fabric. One of the best examples is the Capacity Template v2 for Microsoft Fabric. Check out the blog with lots of screenshots...
techcommunity.microsoft.com/blog/microso...
techcommunity.microsoft.com/blog/microso...
New blog post: MGDC for SharePoint FAQ:
Which dates to use for the Files dataset?
techcommunity.microsoft.com/blog/microso...
Which dates to use for the Files dataset?
techcommunity.microsoft.com/blog/microso...
MGDC for SharePoint FAQ: Which dates to use for the Files dataset? | Microsoft Community Hub
The SharePoint Files dataset became publicly available in Microsoft Graph Data Connect (MGDC) on August 20, 2024. With its release came a unique pricing...
techcommunity.microsoft.com
October 9, 2025 at 3:25 PM
New blog post: MGDC for SharePoint FAQ:
Which dates to use for the Files dataset?
techcommunity.microsoft.com/blog/microso...
Which dates to use for the Files dataset?
techcommunity.microsoft.com/blog/microso...
New blog post on additional regions for MGDC for SharePoint:
MGDC for SharePoint FAQ: Which regions are supported? Updated in September 2025
techcommunity.microsoft.com/blog/microso...
MGDC for SharePoint FAQ: Which regions are supported? Updated in September 2025
techcommunity.microsoft.com/blog/microso...
MGDC for SharePoint FAQ: Which regions are supported? Updated in September 2025 | Microsoft Community Hub
1. Overview
When gathering SharePoint data through Microsoft Graph Data Connect (MGDC), you need to pay attention to an important detail: regions. That...
techcommunity.microsoft.com
September 25, 2025 at 4:21 PM
New blog post on additional regions for MGDC for SharePoint:
MGDC for SharePoint FAQ: Which regions are supported? Updated in September 2025
techcommunity.microsoft.com/blog/microso...
MGDC for SharePoint FAQ: Which regions are supported? Updated in September 2025
techcommunity.microsoft.com/blog/microso...
New post at the MGDC for SharePoint blog:
Capacity Template v2 with Microsoft Fabric.
Optimized version of the Capacity Template now uses Microsoft Fabric.
techcommunity.microsoft.com/blog/microso...
Capacity Template v2 with Microsoft Fabric.
Optimized version of the Capacity Template now uses Microsoft Fabric.
techcommunity.microsoft.com/blog/microso...
Capacity Template v2 with Microsoft Fabric | Microsoft Community Hub
1. Capacity Scenario
One of the most common scenarios for Microsoft Graph Data Connect (MGDC) for SharePoint is Capacity. This scenario focuses...
techcommunity.microsoft.com
September 5, 2025 at 11:29 PM
New post at the MGDC for SharePoint blog:
Capacity Template v2 with Microsoft Fabric.
Optimized version of the Capacity Template now uses Microsoft Fabric.
techcommunity.microsoft.com/blog/microso...
Capacity Template v2 with Microsoft Fabric.
Optimized version of the Capacity Template now uses Microsoft Fabric.
techcommunity.microsoft.com/blog/microso...
New blog post: Using Copilot (GPT-5) to turn schema into SQL and write queries. MGDC schema markdown to CREATE TABLE, plus queries you can use with Fabric.
techcommunity.microsoft.com/blog/microso...
techcommunity.microsoft.com/blog/microso...
Using Copilot (GPT-5) to turn schema into SQL and write queries | Microsoft Community Hub
This article shows a few ways you can use Copilot to help with Microsoft Graph Data Connect for SharePoint. This includes turning a schema into a SQL CREATE...
techcommunity.microsoft.com
September 4, 2025 at 8:14 PM
New blog post: Using Copilot (GPT-5) to turn schema into SQL and write queries. MGDC schema markdown to CREATE TABLE, plus queries you can use with Fabric.
techcommunity.microsoft.com/blog/microso...
techcommunity.microsoft.com/blog/microso...
I got a question today on whether the MGDC users and groups datasets support the SharePoint sampling option. The short answer is no. That MGDC option is only supported with specific SharePoint datasets.
More details in this blog post: techcommunity.microsoft.com/blog/microso...
More details in this blog post: techcommunity.microsoft.com/blog/microso...
MGDC for SharePoint FAQ: Dataset types and features | Microsoft Community Hub
In this post, we’ll discuss the different types of datasets on Microsoft Graph Data Connect (MGDC) for SharePoint and which specific features apply to each...
techcommunity.microsoft.com
August 29, 2025 at 6:44 PM
I got a question today on whether the MGDC users and groups datasets support the SharePoint sampling option. The short answer is no. That MGDC option is only supported with specific SharePoint datasets.
More details in this blog post: techcommunity.microsoft.com/blog/microso...
More details in this blog post: techcommunity.microsoft.com/blog/microso...
I got a question today on how to flatten MGDC for SharePoint datasets when moving the data to a SQL Server or pulling the data into Microsoft Fabric. The answer is in this blog post:
techcommunity.microsoft.com/blog/microso...
techcommunity.microsoft.com/blog/microso...
MGDC for SharePoint FAQ: How to flatten datasets for SQL or Fabric | Microsoft Community Hub
When you get your data from Microsoft Graph Data Connect (MGDC), you will typically get that data as a collection of JSON objects in an Azure Data Lake...
techcommunity.microsoft.com
August 28, 2025 at 5:52 PM
I got a question today on how to flatten MGDC for SharePoint datasets when moving the data to a SQL Server or pulling the data into Microsoft Fabric. The answer is in this blog post:
techcommunity.microsoft.com/blog/microso...
techcommunity.microsoft.com/blog/microso...
The MGDC for SharePoint team is working on a Capacity Template v2 using Microsoft Fabric. It will be similar to the Information Oversharing v2 template (link below) but covering the Capacity scenario.
techcommunity.microsoft.com/blog/microso...
I'll post that new link as soon as it comes out...
techcommunity.microsoft.com/blog/microso...
I'll post that new link as soon as it comes out...
Information Oversharing v2 Template with Microsoft Fabric | Microsoft Community Hub
1. Security Scenario
One of the most common scenarios for Microsoft Graph Data Connect (MGDC) for SharePoint is Information Oversharing. This security...
techcommunity.microsoft.com
July 16, 2025 at 12:24 AM
The MGDC for SharePoint team is working on a Capacity Template v2 using Microsoft Fabric. It will be similar to the Information Oversharing v2 template (link below) but covering the Capacity scenario.
techcommunity.microsoft.com/blog/microso...
I'll post that new link as soon as it comes out...
techcommunity.microsoft.com/blog/microso...
I'll post that new link as soon as it comes out...
New blog post: GA for Microsoft Graph Data Connect for SharePoint.
Details at techcommunity.microsoft.com/blog/microso...
Details at techcommunity.microsoft.com/blog/microso...
Microsoft Graph Data Connect for SharePoint is Generally Available | Microsoft Community Hub
General Availability (GA) for Microsoft Graph Data Connect was announced on August 2023, about two years ago. Details can be found at Microsoft Graph...
techcommunity.microsoft.com
July 2, 2025 at 4:50 PM
New blog post: GA for Microsoft Graph Data Connect for SharePoint.
Details at techcommunity.microsoft.com/blog/microso...
Details at techcommunity.microsoft.com/blog/microso...
I got a question about MGDC for SharePoint today.
Q: Does the SharePoint Files dataset include other list items?
A: No. The SharePoint Files dataset includes only items in a document library.
More about the datasets, including schemas, at aka.ms/SharePointDa...
Q: Does the SharePoint Files dataset include other list items?
A: No. The SharePoint Files dataset includes only items in a document library.
More about the datasets, including schemas, at aka.ms/SharePointDa...
Datasets, regions, and sinks supported by Microsoft Graph Data Connect - Microsoft Graph
Learn about the supported datasets, Microsoft 365 regions, and sink storage types that you can use with Microsoft Graph Data Connect.
aka.ms
June 23, 2025 at 3:58 PM
I got a question about MGDC for SharePoint today.
Q: Does the SharePoint Files dataset include other list items?
A: No. The SharePoint Files dataset includes only items in a document library.
More about the datasets, including schemas, at aka.ms/SharePointDa...
Q: Does the SharePoint Files dataset include other list items?
A: No. The SharePoint Files dataset includes only items in a document library.
More about the datasets, including schemas, at aka.ms/SharePointDa...
I got a question about MGDC for SharePoint today.
Q: How can I estimate my MGDC for SharePoint bill in Azure?
A: Check this article: techcommunity.microsoft.com/blog/microso...
Q: How can I estimate my MGDC for SharePoint bill in Azure?
A: Check this article: techcommunity.microsoft.com/blog/microso...
MGDC for SharePoint FAQ: How can I estimate my Azure bill? Updated! | Microsoft Community Hub
Microsoft Graph Data Connect and related services are billed through Azure meters. This post (updated in October 2024) will help you estimate the cost for...
techcommunity.microsoft.com
June 23, 2025 at 3:53 PM
I got a question about MGDC for SharePoint today.
Q: How can I estimate my MGDC for SharePoint bill in Azure?
A: Check this article: techcommunity.microsoft.com/blog/microso...
Q: How can I estimate my MGDC for SharePoint bill in Azure?
A: Check this article: techcommunity.microsoft.com/blog/microso...
MGDC for SharePoint can get a list of files in the tenant, but does it include OneDrive? Yes, you can get a list of all files in all document libraries, including those in OneDrive, Teams, and others. These are all different types of SharePoint sites.
techcommunity.microsoft.com/blog/microso...
techcommunity.microsoft.com/blog/microso...
MGDC for SharePoint FAQ: Is OneDrive included? | Microsoft Community Hub
The Microsoft Graph Data Connect for SharePoint datasets include all sites in the tenant, including OneDrive sites.
techcommunity.microsoft.com
June 18, 2025 at 3:27 PM
MGDC for SharePoint can get a list of files in the tenant, but does it include OneDrive? Yes, you can get a list of all files in all document libraries, including those in OneDrive, Teams, and others. These are all different types of SharePoint sites.
techcommunity.microsoft.com/blog/microso...
techcommunity.microsoft.com/blog/microso...
New blog post: MGDC for SharePoint FAQ: How to List SharePoint Webs or Subsites? Includes a sample SQL query to enumerate Webs using the Sites and Files datasets.
techcommunity.microsoft.com/blog/microso...
techcommunity.microsoft.com/blog/microso...
MGDC for SharePoint FAQ: How to List SharePoint Webs or Subsites? | Microsoft Community Hub
1. Introduction
SharePoint uses a known object hierarchy to store your files, including, in order:
Site Collection (site, SPSite)
Web (site, subsite,...
techcommunity.microsoft.com
June 12, 2025 at 7:06 PM
New blog post: MGDC for SharePoint FAQ: How to List SharePoint Webs or Subsites? Includes a sample SQL query to enumerate Webs using the Sites and Files datasets.
techcommunity.microsoft.com/blog/microso...
techcommunity.microsoft.com/blog/microso...
Got this question today. How can I get a list of all sites, permissions and files related to SharePoint Embedded in a tenant?
See techcommunity.microsoft.com/blog/microso...
See techcommunity.microsoft.com/blog/microso...
MGDC for SharePoint and SharePoint Embedded | Microsoft Community Hub
1. MGDC for SharePoint and SharePoint Embedded
In this post, we’ll discuss how to use data from Microsoft Graph Data Connect (MGDC) for SharePoint to...
techcommunity.microsoft.com
June 10, 2025 at 4:29 AM
Got this question today. How can I get a list of all sites, permissions and files related to SharePoint Embedded in a tenant?
See techcommunity.microsoft.com/blog/microso...
See techcommunity.microsoft.com/blog/microso...
If you're using Microsoft Graph Data Connect, be sure to regularly update your secret and consent. These typically expire every six months, but you can refresh them in advance to prevent any disruptions.
Details at techcommunity.microsoft.com/blog/microso...
Details at techcommunity.microsoft.com/blog/microso...
Error: Consent not found | Microsoft Community Hub
If you have been using Microsoft Graph Data Connect for a while, you might have configured a recurring pipeline that has been running for several months. In...
techcommunity.microsoft.com
May 27, 2025 at 5:44 PM
If you're using Microsoft Graph Data Connect, be sure to regularly update your secret and consent. These typically expire every six months, but you can refresh them in advance to prevent any disruptions.
Details at techcommunity.microsoft.com/blog/microso...
Details at techcommunity.microsoft.com/blog/microso...
All set to attend the Microsoft 365 Community Conference next week. m365conf.com. My focus is on SharePoint Analytics using the Microsoft Graph Data Connect and SharePoint Advanced Management. If you're planning to be there, reach out via the Whova app or find me at the Microsoft booth at the Expo.
Microsoft 365 Community Conference
Microsoft 365 Community Conference is a premier opportunity to hear experts from Microsoft and around the world share their experience and knowledge about a variety of topics such as cloud services, b...
m365conf.com
April 30, 2025 at 2:45 AM
All set to attend the Microsoft 365 Community Conference next week. m365conf.com. My focus is on SharePoint Analytics using the Microsoft Graph Data Connect and SharePoint Advanced Management. If you're planning to be there, reach out via the Whova app or find me at the Microsoft booth at the Expo.
just stumbled upon this: copilot.microsoft.com/daily
Daily news summary spoken by Copilot, in your chosen voice.
The ingredients were all there...
Daily news summary spoken by Copilot, in your chosen voice.
The ingredients were all there...
April 25, 2025 at 8:31 PM
just stumbled upon this: copilot.microsoft.com/daily
Daily news summary spoken by Copilot, in your chosen voice.
The ingredients were all there...
Daily news summary spoken by Copilot, in your chosen voice.
The ingredients were all there...
I was asked: What is a good overview video on YouTube about Microsoft Graph Data Connect for SharePoint?
A fairly recent one is the demo from the Microsoft 365 & Power Platform weekly call last December. See www.youtube.com/watch?v=ME0L...
A fairly recent one is the demo from the Microsoft 365 & Power Platform weekly call last December. See www.youtube.com/watch?v=ME0L...
Know Thyself - Analytics and insights for SharePoint tenants using the Microsoft Graph Data Connect
YouTube video by Microsoft Community Learning
www.youtube.com
April 21, 2025 at 3:04 PM
I was asked: What is a good overview video on YouTube about Microsoft Graph Data Connect for SharePoint?
A fairly recent one is the demo from the Microsoft 365 & Power Platform weekly call last December. See www.youtube.com/watch?v=ME0L...
A fairly recent one is the demo from the Microsoft 365 & Power Platform weekly call last December. See www.youtube.com/watch?v=ME0L...
New blog: Book of Archimedes, Copilot and SharePoint Agents.
How to use the MGDC for SharePoint blogs with your favorite AI tools.
techcommunity.microsoft.com/blog/microso...
How to use the MGDC for SharePoint blogs with your favorite AI tools.
techcommunity.microsoft.com/blog/microso...
Book of Archimedes, Copilot and SharePoint Agents | Microsoft Community Hub
1. Introduction
The Book of Archimedes is a single PDF that contains all posts in the Microsoft Graph Data Connect for SharePoint blog. This...
techcommunity.microsoft.com
April 17, 2025 at 8:57 PM
New blog: Book of Archimedes, Copilot and SharePoint Agents.
How to use the MGDC for SharePoint blogs with your favorite AI tools.
techcommunity.microsoft.com/blog/microso...
How to use the MGDC for SharePoint blogs with your favorite AI tools.
techcommunity.microsoft.com/blog/microso...
New blog post: Understanding the Notebooks in the Oversharing Template v2 (Microsoft Fabric)
In this post, I describe the two notebooks inside our latest MGDC for SharePoint template, with some help from Copilot...
techcommunity.microsoft.com/blog/microso...
In this post, I describe the two notebooks inside our latest MGDC for SharePoint template, with some help from Copilot...
techcommunity.microsoft.com/blog/microso...
Understanding the Notebooks in the Oversharing Template v2 (Microsoft Fabric) | Microsoft Community Hub
Introduction
The Microsoft Graph Data Connect for SharePoint team published two notebooks used with Microsoft Fabric in the Information Oversharing v2...
techcommunity.microsoft.com
April 14, 2025 at 4:42 PM
New blog post: Understanding the Notebooks in the Oversharing Template v2 (Microsoft Fabric)
In this post, I describe the two notebooks inside our latest MGDC for SharePoint template, with some help from Copilot...
techcommunity.microsoft.com/blog/microso...
In this post, I describe the two notebooks inside our latest MGDC for SharePoint template, with some help from Copilot...
techcommunity.microsoft.com/blog/microso...
After the update to the MGDC for SharePoint Sites schema to include the LastContentChange property, I have updated my blog post titled "How can I track the lifecycle of a SharePoint site?"
techcommunity.microsoft.com/blog/microso...
techcommunity.microsoft.com/blog/microso...
MGDC for SharePoint FAQ: How can I track the lifecycle of a SharePoint site? | Microsoft Community Hub
In this post, we’ll cover details on how to track the lifecycle of a site in MGDC, using the date columns in the SharePoint Sites dataset.
techcommunity.microsoft.com
March 27, 2025 at 9:01 PM
After the update to the MGDC for SharePoint Sites schema to include the LastContentChange property, I have updated my blog post titled "How can I track the lifecycle of a SharePoint site?"
techcommunity.microsoft.com/blog/microso...
techcommunity.microsoft.com/blog/microso...
After the update to the MGDC for SharePoint Groups schema to include the LoginName property, I updated the blog "How are SharePoint Groups and Security Groups used together?" The _o suffix in the LoginName plays a unique role here. See if you can spot it.
techcommunity.microsoft.com/blog/microso...
techcommunity.microsoft.com/blog/microso...
MGDC for SharePoint FAQ: How are SharePoint Groups and Security Groups used together? | Microsoft Community Hub
This article explores how SharePoint groups are used together with Microsoft Entra ID Security groups.
techcommunity.microsoft.com
March 27, 2025 at 3:19 PM
After the update to the MGDC for SharePoint Groups schema to include the LoginName property, I updated the blog "How are SharePoint Groups and Security Groups used together?" The _o suffix in the LoginName plays a unique role here. See if you can spot it.
techcommunity.microsoft.com/blog/microso...
techcommunity.microsoft.com/blog/microso...
New blog post: MGDC for SharePoint: New Columns in Q1 CY2025
techcommunity.microsoft.com/blog/microso...
techcommunity.microsoft.com/blog/microso...
MGDC for SharePoint: New Columns in Q1 CY2025 | Microsoft Community Hub
The MGDC for SharePoint team continues to improve the available datasets.
This time around, we are introducing additional columns to some of our...
techcommunity.microsoft.com
March 27, 2025 at 2:37 AM
New blog post: MGDC for SharePoint: New Columns in Q1 CY2025
techcommunity.microsoft.com/blog/microso...
techcommunity.microsoft.com/blog/microso...
Got a question today: The MGDC dataset I gathered has tens of millions of rows and Power BI is struggling to handle it. What do I do?
The answer is at techcommunity.microsoft.com/blog/microso...
The answer is at techcommunity.microsoft.com/blog/microso...
March 26, 2025 at 8:27 PM
Got a question today: The MGDC dataset I gathered has tens of millions of rows and Power BI is struggling to handle it. What do I do?
The answer is at techcommunity.microsoft.com/blog/microso...
The answer is at techcommunity.microsoft.com/blog/microso...