IMPORTANT NOTE: This blog post is no longer current. Please visit the latest version of this blog in the official Microsoft Graph Data Connect for SharePoint blog in the Tech Community web site. Introduction Microsoft Graph Data Connect for SharePoint delivers rich data assets to OneDrive and SharePoint tenants, so they can run their own … Continue reading Links about Microsoft Graph Data Connect for SharePoint
Blog
Talking to Copilot about Power BI Calculated Columns and Measures
I had a conversation with Copilot about how to create and use calculated columns and measures in Power BI. I recently had a discussion about this because I learned that when I use a LakeHouse table from Power BI, I can only create measures, but not calculated columns. Copilot did a great job explaining details … Continue reading Talking to Copilot about Power BI Calculated Columns and Measures
Copilot is so good at manipulating data
One of the less known capabilities in Copilot is the ability to transform text in lists. I recently had to transform a list of companies from one format to another. It's one of those things that I used to do with Word or Excel, like sorting, removing a number from the beginning of a line … Continue reading Copilot is so good at manipulating data
Microsoft Graph Data Connect for SharePoint – Oversharing for Very Large Tenants
IMPORTANT NOTE: This blog post is no longer current. Please visit the latest version of this blog in the official Microsoft Graph Data Connect for SharePoint blog in the Tech Community web site. 0. Introduction If you have a large SharePoint tenant (with hundreds of thousands of sites), you might run into some issues while trying … Continue reading Microsoft Graph Data Connect for SharePoint – Oversharing for Very Large Tenants
Counting Microsoft Entra ID (Azure Active Directory) Groups
Groups and Permissions If you use Microsoft Graph Data Connect for SharePoint, you know that the datasets from SharePoint will give detailed permissions, including which users have access to sites, libraries, folders and files. However, permissions are frequently granted to Microsoft Entra ID (new name for Azure Active Directory) groups. To fully understand how many … Continue reading Counting Microsoft Entra ID (Azure Active Directory) Groups
MGDC for SharePoint – Updated on 11/2023
I would like to share some exciting news for the Microsoft Graph Data Connect for SharePoint (Project Archimedes). First, we published updated schema documents for our 3 existing datasets. These new docs include more details like scenarios, questions the dataset answers and how it can be joined to other datasets, in addition to the traditional … Continue reading MGDC for SharePoint – Updated on 11/2023
Microsoft Graph Data Connect for SharePoint FAQ: How can I estimate my Azure bill?
IMPORTANT NOTE: This blog post is no longer current. Please visit the latest version of this blog in the official Microsoft Graph Data Connect for SharePoint blog in the Tech Community web site. Introduction When gathering SharePoint data through Microsoft Graph Data Connect, you are billed through Azure. As I write this blog, the price to … Continue reading Microsoft Graph Data Connect for SharePoint FAQ: How can I estimate my Azure bill?
MGDC for SharePoint – Overview and prerequisites
You can use the Microsoft Graph Data Connect for SharePoint to extract SharePoint and OneDrive information and use that to run analytics for your tenant. You get data in an Azure Storage account owned by the tenant, and you can easily transform and visualize the data. For example, if you're looking at the SharePoint Sites … Continue reading MGDC for SharePoint – Overview and prerequisites
MGDC for SharePoint – Update on 08/2023
0. Overview There have been a lot of changes in Microsoft Graph Data Connect for SharePoint (a.k.a. Project Archimedes) recently. Let’s take a moment to review these key changes, which can be grouped into three main categories: the public preview phase, enhancements to the setup process, and the introduction of new documentation. 1. Public Preview … Continue reading MGDC for SharePoint – Update on 08/2023
Step-by-step: Gathering a detailed dataset on your SharePoint Sites (New Consent)
A step-by-step guide to getting SharePoint Sites information using the Microsoft Graph Data Connect, Azure Synapse and Power BI IMPORTANT NOTE: This blog post is no longer current. Please visit the latest version of this blog in the official Microsoft Graph Data Connect for SharePoint blog in the Tech Community web site. IMPORTANT NOTE: This … Continue reading Step-by-step: Gathering a detailed dataset on your SharePoint Sites (New Consent)
SharePoint on MGDC FAQ: What is the size of my sites?
IMPORTANT NOTE: This blog post is no longer current. Please visit the latest version of this blog in the official Microsoft Graph Data Connect for SharePoint blog in the Tech Community web site. 1. Introduction How much storage is being used by your SharePoint sites? Sounds like a simple question, but there are lots of details … Continue reading SharePoint on MGDC FAQ: What is the size of my sites?
Jose Barreto's Blog 