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

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

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/microsoft…

New blog post: MGDC for SharePoint: New Columns in Q1 CY2025 techcommunity.microsoft.com/blog/microsoft…

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/microsoft…

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/microsoft…

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/microsoft…

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/microsoft…

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 youtube.com/watch?v=ME0LAu…

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

just stumbled upon this: copilot.microsoft.com/daily Daily news summary spoken by Copilot, in your chosen voice. The ingredients were all there...

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. Reach out via the Whova app or find me at the Microsoft booth at the Expo

Running final scripts. Environment looks good. ✅ Microsoft Build has officially arrived in Seattle, join us live for the opening keynote tomorrow, May 19th, at 9:05am PT: build.microsoft.com/?wt.mc_ID=Buil…

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/microsoft…

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/microsoft…

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/microsoft…

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/microsoft…

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/SharePointData…

New blog post: GA for Microsoft Graph Data Connect for SharePoint. Details at techcommunity.microsoft.com/blog/microsoft…

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/microsoft… I'll post that new link as soon as it comes out...