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...

New blog post: MGDC for SharePoint FAQ: 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...

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...

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...

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...

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...

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...

New blog post: GA for Microsoft Graph Data Connect for SharePoint. 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...

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...

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...

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...

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...

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...

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...

Watching the FabCon keynote Microsoft Fabric: Vision and Roadmap www.youtube.com/watch?v=bI6m...

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...

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...

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...

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...

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...

New blog post: MGDC for SharePoint: New Columns in Q1 CY2025 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...

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).

When creating your pipeline in Synapse, this is an expression for "two days ago": @formatDateTime(addDays(utcNow(),-2),'yyyy-MM-ddTHH:mm:ss')

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

Calculate Pi in PowerShell... github.com/Jose-Barreto... Happy Pi Day!

We'll commit to a slice 🥧 Happy Pi Day!

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...

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...

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...

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...

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...

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...

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.

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...

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...

💡 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 → https://youtu.be/ME0LAuNYpe0 #Microsoft365Dev #MicrosoftGraph #SharePoint

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...

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...

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...

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

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...

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.

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...

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...

SharePoint AI-powered agents are created as files with the ".agent" extension. That means you can use the MGDC for SharePoint Files dataset to understand how they are being created anywhere in the tenant. support.microsoft.com/en-us/office...

I got questions today about if/how you can use MGDC find the SharePoint Sites that are associated with Microsoft Teams. We do have 3 columns in the Sites dataset related to that: IsTeamsConnectedSite, IsTeamsChannelSite and TeamsChannelType. More at github.com/microsoftgra...