Microsoft Graph Data Connect for SharePoint – M365 Conference Demo
For those that could not attend the recent Microsoft 365 conference, I have a demo of the Microsoft Graph Data Connect for SharePoint at: https://www.youtube.com/watch?v=hdPKM835ICY. The video shows how to check the required pre-requisites in Microsoft 365 and Azure, how to trigger the pipeline from Azure Synapse, and how to show the data in a…
9 regions now available for SharePoint Data via Microsoft Graph Data Connect
This is a quick blog to share that the SharePoint datasets in Microsoft Graph Data Connect are now available in 9 regions, up from 5 regions previously. Here’s the updated list: Office regionAzure regionsAsia-PacificEast AsiaSoutheast AsiaAustraliaAustralia EastAustralia SoutheastBrazilBrazil SouthBrazil SoutheastCanadaCanada CentralCanada EastEuropeNorth EuropeWest EuropeFranceFrance CentralJapanJapan EastJapan WestNorth AmericaCentral USEast USEast US 2North Central USSouth Central…
SharePoint on MGDC FAQ: Is OneDrive included?
1. SharePoint datasets and OneDrive When I describe the SharePoint datasets in Microsoft Graph Data Connect (MGDC) to someone, I frequently get this question: do Sites and Sharing cover only SharePoint or do they include OneDrive? The short answer is that OneDrive is included, but there is much more to say here… 2. OneDrive is…
SharePoint on MGDC FAQ: How do I process Deltas?
This is a follow up on the two blogs about delta datasets. If you haven’t read them yet, take a look: Our team got some follow-up questions on this, so I thought it would make sense to write a little more and make things clear. First of all, from the last blog above, the basic…
SharePoint on MGDC FAQ: What counts as an object?
1. Overview When gathering SharePoint data through Microsoft Graph Data Connect (MGDC), you are billed through Azure. You can find the official MGDC pricing information at Pricing – Microsoft Graph Data Connect. As I write this blog, the price to pull 1,000 objects from MGDC in the US is $0.375. Since the MGDC basic rate…
Links about SharePoint on Microsoft Graph Data Connect
Introduction Microsoft Graph Data Connect delivers rich data assets to OneDrive and SharePoint tenants, so they can run their own analytics, derive insights from their data and understand how they use these products. The data is transferred to an Azure account owned by the tenant, where they can use tools like Azure Synapse and Power…
SharePoint on MGDC FAQ: Which regions are supported?
Important P.S.: Since the publication of this blog, SharePoint Data in MGDC was expanded from 5 regions to 9 regions. Read more about them at https://barreto.home.blog/2023/05/07/9-regions-now-available-for-sharepoint-data-via-mgdc/ 1. Overview When gathering SharePoint data through Microsoft Graph Data Connect (MGDC), you need to pay attention to an important detail: regions. That includes both the region of your…
Asking ChatGPT and the new Bing for help with merging a Delta dataset (SharePoint Data on MGDC)
I was considering if ChatGPT could help me write SQL code to merge a SharePoint Delta State Dataset, like the ones we are now offering using the Microsoft Graph Data Connect (MGDC). If you’re new to the scenario, you can read about it at this blog post: SharePoint on MGDC FAQ: How can I use…
SharePoint on MGDC FAQ: How can I use Delta State Datasets?
1. Overview When gathering SharePoint data through Microsoft Graph Data Connect in a large tenant, you might be pulling many thousands or even millions of objects. If you want to always have the latest information available, you will likely run your pipeline daily. In this blog, we’ll investigate how you can use what we call…
SharePoint on MGDC FAQ: Which date should I query?
1. Filter by SnapShotDate When gathering SharePoint data through Microsoft Graph Data Connect (MGDC), you must choose the date to query. This is expressed as a required filter on the SnapshotDate column (see picture below for an example using the Synapse Copy Data tool). You typically want the “Start time” and “End time” to be…
Four Options for SharePoint Site Analytics
Overview Here’s a scenario: imagine that you are a SharePoint Online administrator and you have been asked to provide analytics about how the company is leveraging these resources. You want to understand: Well, Microsoft offers you a few options… Option 1: Admin Portal Usage Reports You can get some site information from the Microsoft 365…
Loading CSV/text files with more than a million rows into Excel
1. The Problem If you usually load a very large CSV (comma-separated values) file or text file into Excel, you might run into the dreaded “File not loaded completely” message: As the message explains, the file you are trying to load is too large for Excel to handle. For me, it typically happens with large…
Broken image link? Search the archive…
I blogged for 15 years using the old TechNet blogs sites, under the https://blogs.technet.com/josebda URL. As you can tell if you click on that old link, it’s no longer there. That blog service was closed, but there is an archive at https://learn.microsoft.com/en-us/archive/blogs/josebda/ including all the hundreds of posts from 2004 to 2018. I also backed…
Scary SQL Server stuff: tombstones, phantoms, ghosts and zombies
This post mixes the spirit of Halloween and the passion for SQL Server 🙂 Have you noticed how SQL Server has a number of things that seem right out of a horror movie? As a test of your SQL Server expertise and for a fun Halloween trivia game, try to describe the items in…
Step-by-step: Gathering a detailed dataset on your SharePoint Sites
A step-by-step guide to getting SharePoint Sites information using the Microsoft Graph Data Connect, Azure Synapse and Power BI 0. Overview This blog shows the step-by-step instructions on how to extract SharePoint and OneDrive site information and use that to run analytics for your tenant. If you follow these steps, you will have a Power…
SharePoint and OneDrive + Microsoft Graph Data Connect + Ignite 2022
The Ignite 2022 conference this week brought a number of presentations and announcements from all over Microsoft. For me in the OneDrive and SharePoint team, there were plenty of news. In my opinion, the biggest story is around Content AI and the announcement of Microsoft Syntex. If you haven’t seen it yet, I would highly…
Microsoft Ignite 2022 – Session Catalog
The Session Catalog for the Microsoft Ignite 2022 event is out. The event is 10 days away (October 12th to the 14th) and you can stream many of the sessions online . As of 10/02/2022 at 1PM, the catalog shows 794 sessions, which is quite a lot and requires some planning. Here’s the breakdown by…
PowerShell cmdlets and parameters for the SharePoint Online module
This is a simple list of all the cmdlets in the Microsoft.Online.SharePoint.PowerShell module. This is a useful module for an Administrator using SharePoint Online or OneDrive for Business. Here are a few notes: If you don’t have the module, you can install it using the following cmdlet: Install-Module -Name Microsoft.Online.SharePoint.PowerShell Before you can use most…
PowerShell Examples in my GitHub Repo
I just uploaded a few of my PowerShell samples to GitHub at https://github.com/Jose-Barreto/PowerShell. Many were mentioned in previous blog posts: But not every file in that GitHub repo is documented in a blog post. Some are just some small tests and samples: I’ve been using PowerShell since the early days when it was still called…
Long time no post…
Hi! It’s been a while since I last wrote a blog post here (or anywhere else). I used to post a lot when I was working on public facing features for Windows Server and the SMB file protocol. After that, I moved to the OneDrive team and worked on some internal stuff, continuing the trend…