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!
