just stumbled upon this: copilot.microsoft.com/daily

Daily news summary spoken by Copilot, in your chosen voice.

The ingredients were all there...

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

When creating your pipeline in Synapse, this is an expression for "two days ago":

@formatDateTime(addDays(utcNow(),-2),'yyyy-MM-ddTHH:mm:ss')

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

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

I downloaded all the public blog posts about MGDC for SharePoint (see aka.ms/SharePointData) into a single word document that I can feed to Copilot as grounding. I then tried asking copilot a lot of different questions about the datasets, scenarios, etc. I call it "The Book of Archimedes" 😊

The slides for Microsoft Graph Data Connect for SharePoint (aka Project Archimedes) are now available at aka.ms/SharePointDa...

This is published as an attachment to the main blog for MGDC for SharePoint at aka.ms/SharePointData

Poll is closed. Here are the results:

We currently have Sites, Groups, Permissions, Files, File Actions, Sync Health and Sync Errors as datasets for MGDC for SharePoint. For 2025, what additional datasets would you like to see?

1 new blog, 1 updated blog

Just a quick update to share that I updated to the Capacity Template blog with additional screenshots and also added a new blog for the Information Oversharing template.

techcommunity.microsoft.com/t5/microsoft...

New article in the SharePoint Learn page: SharePoint Storage Planning
learn.microsoft.com/en-us/sharep...

The MGDC for SharePoint Capacity Template is available. It includes instructions on how to get started, a Synapse pipeline template and a Power BI template. I am working on a new blog post introducing it.

In the meantime, you can read more at github.com/microsoftgra...

Diving deep into the SharePoint File Actions dataset.

github.com/microsoftgra...

Working with MGDC for SharePoint + Microsoft Fabric. Just ran a pipeline to get SharePoint sites metadata into a Lakehouse table...