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 MGDC
Introduction Microsoft Graph Data Connect (MGDC) 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…
SharePoint on MGDC FAQ: Which regions are supported?
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 Microsoft 365 tenant (the data source) and the region of the Azure Storage account (the data destination). In this blog, we’ll investigate the importance of understanding…
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 (MGDC) 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…
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…
Gathering a detailed dataset on your SharePoint Sites
A step-by-step guide to getting SharePoint Sites information using the Microsoft Graph Data Connect (MGDC), 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…
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…
Brazilian Saying: Soft water on hard stone
Portuguese: Água mole em pedra dura tanto bate até que fura Literal translation: Soft water on hard stone hits until it bores through English equivalent: Little strokes fell big oaks Meaning: If you persevere long enough, the desired effect will eventually be achieved. Note: This blog is part of a series on Brazilian Sayings (in…
Brazilian Saying: Without papers
Portuguese: Sem lenço, sem documento. Literal translation: Without a handkerchief, without papers. English equivalent: Without a care in the world. Meaning: Having no concerns or worries. This assumes that someone that bothers to carry papers and a handkerchief is worried about what lies ahead. Mentioned in (originated from?) the 1967 Brazilian song “Alegria, Alegria” by…
Brazilian Saying: To feed steak to a cat
Portuguese: Dar carne a gato. Literal translation: To feed steak to a cat. English equivalent: To loosen the ropes. Meaning: To make it easy for someone, particularly for someone smart or skilled. The cat is supposedly an efficient predator that can catch their own prey. Note: This blog is part of a series on Brazilian…
Brazilian Saying: Two rabbits
Portuguese: Matar dois coelhos com uma cajadada só. Literal translation: To kill two rabbits with one blow of the stick. English equivalent: To kill two birds with one stone. Meaning: To achieve multiple results with a single action. Sometimes used simply as “matar dois coelhos” (to kill two rabbits), without the rest of the phrase.…