Sign in

Jose Barreto

@josebarreto.bsky.social
84 followers 46 following 85 posts

Jose Barreto is a Principal PM Architect in the E+D Division at Microsoft, focusing on SharePoint and OneDrive. These are my personal opinions.

PostsRepliesMedia
Jose Barreto @josebarreto.bsky.social · 03/09/2026
We’ve completed updates to Microsoft Graph Data Connect for SharePoint, adding new columns to the Sites, Groups, Permissions, and Files datasets. More at: techcommunity.microsoft.com/blog/microso... Updated schemas at: aka.ms/SharePointDa...
techcommunity.microsoft.com
MGDC for SharePoint: New Columns in September 2026 | 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 existing...
000
Jose Barreto @josebarreto.bsky.social · 31/08/2026
New blog post on Microsoft Graph Data Connect: MGDC for SharePoint: AadObjectId may sometimes be missing in User metadata (fixed) techcommunity.microsoft.com/blog/microso...
techcommunity.microsoft.com
MGDC for SharePoint: AadObjectId may sometimes be missing in User metadata (fixed) | Microsoft Community Hub
We identified issues affecting specific Microsoft Graph Data Connect (MGDC) for SharePoint scenarios. In some cases, user identity records in the SharePoint...
000
Jose Barreto @josebarreto.bsky.social · 09/10/2025
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
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...
020
Jose Barreto @josebarreto.bsky.social · 09/10/2025
New blog post: MGDC for SharePoint FAQ: Which dates to use for the Files dataset? techcommunity.microsoft.com/blog/microso...
techcommunity.microsoft.com
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...
020
Jose Barreto @josebarreto.bsky.social · 25/09/2025
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...
techcommunity.microsoft.com
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...
010
Jose Barreto @josebarreto.bsky.social · 06/09/2025
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...
techcommunity.microsoft.com
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...
010
Jose Barreto @josebarreto.bsky.social · 04/09/2025
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
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...
000
Jose Barreto @josebarreto.bsky.social · 29/08/2025
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...
techcommunity.microsoft.com
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...
010
Jose Barreto @josebarreto.bsky.social · 28/08/2025
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
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...
020
Jose Barreto @josebarreto.bsky.social · 16/07/2025
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
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...
000
Jose Barreto @josebarreto.bsky.social · 02/07/2025
New blog post: GA for Microsoft Graph Data Connect for SharePoint. Details at techcommunity.microsoft.com/blog/microso...
techcommunity.microsoft.com
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...
000
Jose Barreto @josebarreto.bsky.social · 23/06/2025
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...
aka.ms
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.
000
Jose Barreto @josebarreto.bsky.social · 23/06/2025
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...
techcommunity.microsoft.com
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...
000
Jose Barreto @josebarreto.bsky.social · 18/06/2025
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
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.
001
Jose Barreto @josebarreto.bsky.social · 12/06/2025
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
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,...
000
Jose Barreto @josebarreto.bsky.social · 10/06/2025
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...
techcommunity.microsoft.com
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...
000
Jose Barreto @josebarreto.bsky.social · 27/05/2025
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...
techcommunity.microsoft.com
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...
001
Jose Barreto @josebarreto.bsky.social · 30/04/2025
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.
m365conf.com
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...
010
Jose Barreto @josebarreto.bsky.social · 25/04/2025
just stumbled upon this: copilot.microsoft.com/daily Daily news summary spoken by Copilot, in your chosen voice. The ingredients were all there...
000
Jose Barreto @josebarreto.bsky.social · 23/04/2025
Watching the FabCon keynote Microsoft Fabric: Vision and Roadmap www.youtube.com/watch?v=bI6m...
youtube.com
Microsoft Fabric: Vision & Roadmap (FabCon Keynote part one)
YouTube video by Microsoft Fabric
000
Jose Barreto @josebarreto.bsky.social · 21/04/2025
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...
youtube.com
Know Thyself - Analytics and insights for SharePoint tenants using the Microsoft Graph Data Connect
YouTube video by Microsoft Community Learning
000
Jose Barreto @josebarreto.bsky.social · 17/04/2025
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...
techcommunity.microsoft.com
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...
000
Jose Barreto @josebarreto.bsky.social · 14/04/2025
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...
techcommunity.microsoft.com
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...
000
Jose Barreto @josebarreto.bsky.social · 27/03/2025
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
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.
110
Jose Barreto @josebarreto.bsky.social · 27/03/2025
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
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.
000
Jose Barreto @josebarreto.bsky.social · 27/03/2025
New blog post: MGDC for SharePoint: New Columns in Q1 CY2025 techcommunity.microsoft.com/blog/microso...
techcommunity.microsoft.com
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...
011
Jose Barreto @josebarreto.bsky.social · 26/03/2025
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...
000
Jose Barreto @josebarreto.bsky.social · 19/03/2025
Someone just asked me for a slide deck that covers the details on Microsoft Graph Data Connect (MGDC) for SharePoint. You can find some slides at aka.ms/SharePointData (look for the PDF attachment at the end).
aka.ms
Links about Microsoft Graph Data Connect for SharePoint | Microsoft Community Hub
This blog offers a collection of links related to Microsoft Graph Data Connect for SharePoint.
010
Jose Barreto @josebarreto.bsky.social · 18/03/2025
When creating your pipeline in Synapse, this is an expression for "two days ago": @formatDateTime(addDays(utcNow(),-2),'yyyy-MM-ddTHH:mm:ss')
000
Jose Barreto @josebarreto.bsky.social · 18/03/2025
Need a full list of all Files in an M365 tenant? Do it site-by-site following the aka.ms/ScanGuidance or use a single request to MGDC for SharePoint as described at aka.ms/SharePointData
aka.ms
Best practices for discovering files and detecting changes at scale - OneDrive dev center
010
Jose Barreto @josebarreto.bsky.social · 14/03/2025
Calculate Pi in PowerShell... github.com/Jose-Barreto... Happy Pi Day!
github.com
PowerShell/Calculate Pi.ps1 at master · Jose-Barreto/PowerShell
PowerShell samples for beginngers. Contribute to Jose-Barreto/PowerShell development by creating an account on GitHub.
000
Reposted by Jose Barreto
GitHub @github.com · 14/03/2025
We'll commit to a slice 🥧 Happy Pi Day!
220125391096
Jose Barreto @josebarreto.bsky.social · 14/03/2025
Q: How can MGDC for SharePoint find out about how many agents exists in the tenant, when they were created? A: Agents are created as files with the ".agent" extension. You can use the Files dataset to understand how they are being created in the tenant. support.microsoft.com/en-us/office...
support.microsoft.com
Create and edit an agent - Microsoft SupportYour Privacy Choices Opt-Out Icon
Create and customize agents in SharePoint to streamline workflows, enhance collaboration, and quickly access information from tailored knowledge sources
010
Jose Barreto @josebarreto.bsky.social · 13/03/2025
Q: When running Microsoft Fabric, how do I define the Azure region, so it matches the region in MGDC region? A: When creating the Fabric capacity, make sure to specify the matching region. See more at learn.microsoft.com/en-us/fabric...
learn.microsoft.com
Manage your Fabric capacity - Microsoft Fabric
Learn how to manage your Microsoft Fabric capacity and understand that different settings that are available to you.
000
Jose Barreto @josebarreto.bsky.social · 12/03/2025
The SharePoint oversharing template for Microsoft Fabric has key updates: uses UserCount columns, pulls just Sites and Permissions datasets, implements deltas, and flattens the permission dataset. More at techcommunity.microsoft.com/blog/microso...
techcommunity.microsoft.com
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...
020
Jose Barreto @josebarreto.bsky.social · 11/03/2025
I got a question today about what primary keys to use when merging delta datasets in Microsoft Graph Data Connect for SharePoint. The answer is at techcommunity.microsoft.com/blog/microso...
techcommunity.microsoft.com
MGDC for SharePoint FAQ: How can I use Delta State Datasets? | Microsoft Community Hub
You can use Delta State Datasets to optimize recurring data transfers through Microsoft Graph Data Connect for SharePoint.
000
Jose Barreto @josebarreto.bsky.social · 07/03/2025
New blog post: Information Oversharing v2 Template with Microsoft Fabric Optimized version of the Oversharing template now uses Microsoft Fabric techcommunity.microsoft.com/blog/microso...
techcommunity.microsoft.com
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...
000
Jose Barreto @josebarreto.bsky.social · 07/03/2025
I got a question on how to use Excel instead of Power BI to pull the Microsoft Graph Data Connect datasets, stored as JSON files in an Azure Storage account. The answer is in the article at techcommunity.microsoft.com/blog/microso...
techcommunity.microsoft.com
MGDC for SharePoint FAQ: How to use Excel for analytics | Microsoft Community Hub
MGDC for SharePoint – Dataset types and features In this post, we’ll discuss how to use Microsoft Excel to consume the data from Microsoft Graph Data Connect...
011
Jose Barreto @josebarreto.bsky.social · 04/03/2025
I am getting used to writing partially incorrect SQL statements (another language's syntax for expressions) and just feed that to Copilot to get the correct SQL syntax. It's like writing a hard-to-spell word in a document. You just need to get it close enough so the spellchecker can help.
010
Jose Barreto @josebarreto.bsky.social · 25/02/2025
Someone asked me today about how to retrieve SharePoint metadata for analytics on sites and files. The answer is in this blog post: Four Options for SharePoint Site Analytics techcommunity.microsoft.com/blog/microso...
010
Jose Barreto @josebarreto.bsky.social · 20/02/2025
Got a question today about throttling. The answer was in the page about “Avoid getting throttled or blocked in SharePoint Online”. learn.microsoft.com/en-us/sharep...
learn.microsoft.com
Avoid getting throttled or blocked in SharePoint Online
Learn about throttling in SharePoint Online and learn how to avoid being throttled or blocked.
000
Reposted by Jose Barreto
Vesa Juvonen @vesajuvonen.bsky.social · 17/02/2025
💡 Discover how to gain analytics and insights for SharePoint tenants using Microsoft Graph Data Connect! Let @josebarreto.bsky.social guide you through tenant data with powerful analytics. 📺 Watch the demo here → youtu.be/ME0LAuNYpe0 #Microsoft365Dev #MicrosoftGraph #SharePoint
023
Jose Barreto @josebarreto.bsky.social · 18/02/2025
I learned today that Microsoft Fabric warehouses by default are configured with case-sensitive (CS) collation. However, there is a way to create a warehouse with case-insensitive (CI) collation. Details at learn.microsoft.com/en-us/fabric...
learn.microsoft.com
How to: Create warehouses with case-insensitive (CI) collation - Microsoft Fabric
Learn how to create a Fabric warehouse with case-insensitive collation through the RESTful API. The article also explains how to use Visual Studio Code with the REST Client extension to facilitate the...
000
Jose Barreto @josebarreto.bsky.social · 13/02/2025
New blog on "Error: Consent not found" explains a common error related to MGDC for SharePoint, how to fix it when it happens and how to avoid it before it happens. techcommunity.microsoft.com/blog/microso...
techcommunity.microsoft.com
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...
000
Jose Barreto @josebarreto.bsky.social · 06/02/2025
I got a question today about using Microsoft Graph Data Connect for SharePoint with Microsoft Fabric. Yes, that is supported, and we have step-by-step instructions at techcommunity.microsoft.com/blog/microso...
techcommunity.microsoft.com
Step-by-step: (Microsoft Fabric) Gather a detailed dataset on SharePoint Sites using MGDC | Microsoft Community Hub
This blog shows a step-by-step guide to getting SharePoint Sites information using the Microsoft Graph Data Connect for SharePoint and the Microsoft...
010
Jose Barreto @josebarreto.bsky.social · 28/01/2025
The main MGDC for SharePoint blog post now includes two attachments. One is an overview presentation, and the other is the "Book of Archimedes," which contains over 350 pages of blog posts on MGDC for SharePoint. Check these two attached files at aka.ms/SharePointData
aka.ms
Links about Microsoft Graph Data Connect for SharePoint | Microsoft Community Hub
This blog offers a collection of links related to Microsoft Graph Data Connect for SharePoint.
031
Jose Barreto @josebarreto.bsky.social · 22/01/2025
I got a question today about how SharePoint defines the permissions for the Microsoft 365 group-connected sites. The answer is in this blog: techcommunity.microsoft.com/blog/microso...
techcommunity.microsoft.com
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.
000
Jose Barreto @josebarreto.bsky.social · 22/01/2025
Got a question today about using Excel to do analysis on data coming from Microsoft Graph Data Connect for SharePoint. I have an overview at techcommunity.microsoft.com/blog/microso... This includes a tip on how to load datasets with over 1 million rows into Excel.
techcommunity.microsoft.com
MGDC for SharePoint FAQ: How to use Excel for analytics | Microsoft Community Hub
MGDC for SharePoint – Dataset types and features In this post, we’ll discuss how to use Microsoft Excel to consume the data from Microsoft Graph Data Connect...
011
Jose Barreto @josebarreto.bsky.social · 14/01/2025
New blog post: MGDC for SharePoint and SharePoint Embedded How to use data from Microsoft Graph Data Connect (MGDC) for SharePoint to understand how SharePoint Embedded is being configured and used in your tenant. techcommunity.microsoft.com/blog/microso...
techcommunity.microsoft.com
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...
000
Jose Barreto @josebarreto.bsky.social · 13/01/2025
I am working on a new blog post on how to use Microsoft Graph Data Connect for SharePoint with SharePoint Embedded. learn.microsoft.com/en-us/sharep...
learn.microsoft.com
SharePoint Embedded Overview
Microsoft SharePoint Embedded is a cloud-based file and document management system suitable for use in any application. SharePoint Embedded is a new API-only solution that enables app developers to ha...
000