Jose Barreto
josebarreto.bsky.social
Jose Barreto
@josebarreto.bsky.social
Jose Barreto is a Principal PM Architect in the E+D Division at Microsoft, focusing on SharePoint and OneDrive. These are my personal opinions.
just stumbled upon this: copilot.microsoft.com/daily

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

The ingredients were all there...
April 25, 2025 at 8:31 PM
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...
March 26, 2025 at 8:27 PM
When creating your pipeline in Synapse, this is an expression for "two days ago":

@formatDateTime(addDays(utcNow(),-2),'yyyy-MM-ddTHH:mm:ss')
March 18, 2025 at 11:28 PM
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...
February 25, 2025 at 8:28 PM
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...
January 9, 2025 at 8:30 PM
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" 😊
January 7, 2025 at 5:47 PM
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
November 27, 2024 at 8:30 PM
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?
November 22, 2024 at 6:48 PM
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...
October 24, 2024 at 4:08 PM
New article in the SharePoint Learn page: SharePoint Storage Planning
learn.microsoft.com/en-us/sharep...
October 14, 2024 at 9:27 PM
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...
October 10, 2024 at 9:06 PM
Diving deep into the SharePoint File Actions dataset.

github.com/microsoftgra...
September 20, 2024 at 4:26 PM
Working with MGDC for SharePoint + Microsoft Fabric. Just ran a pipeline to get SharePoint sites metadata into a Lakehouse table...
September 19, 2024 at 9:43 PM