Capacity Template v2 with Microsoft Fabric
1. Capacity Scenario One of the most common scenarios for Microsoft Graph Data Connect (MGDC) for SharePoint is Capacity. This scenario focuses on identifying which sites and files are using the most storage, along with understanding the distribution of these large sites and files by properties like type and age. The MGDC datasets for this scenario are SharePoint Sites and SharePoint Files. If you’re not familiar with these datasets, you can find details in the schema definitions at https://aka.ms/SharePointDatasets. To assist you in using these datasets, the team has developed a Capacity Template. Initially published as a template for Azure Synapse, we now have a new Microsoft Fabric template that is simpler and offers more features. This SharePoint Capacity v2 Template, based on Microsoft Fabric, is now publicly available. 2. Instructions The template comes with a set of detailed instructions at https://aka.ms/fabriccapacitytemplatesteps. These instructions include: How to install the Microsoft Fabric and Microsoft Graph Data Connect prerequisites How to import the pipeline template from the Microsoft Fabric gallery and set it up How to import the Power BI template and configure the data source settings See below some additional details about the template. 3. Microsoft Fabric Pipeline After you import the pipeline template, it will look like this: 4. Pipeline in Microsoft Fabric The Capacity template for Microsoft Fabric includes a few key improvements: The new template uses delta datasets to update the SharePoint Sites and SharePoint Files datasets. It keeps track of the last time the datasets were pulled by this pipeline, requesting just what changed since then. The new template uses views to do calculations and create new properties like size bands or date bands. In our previous template, this was done in Power Query, when importing into Power BI. The new template also uses a view to aggregate file data, grouping the data by file extension. You can find details on how to find and deploy the Microsoft Fabric template in the instructions (see item 3). 5. Microsoft Fabric Report The typical result from this solution is a set of Power BI dashboards pulled from the Microsoft Fabric data source. Here are some examples: These dashboards serve as examples or starting points and can be modified as necessary for various visualizations of the data within these datasets. The instructions (see item 3) include details on how to find and deploy a few sample Power BI Capacity templates. 6. Conclusion I hope this provides a good overview of the Capacity template for Microsoft Fabric. You can read more about the Microsoft Graph Data Connect for SharePoint at https://aka.ms/SharePointData. There you will find many details, including a list of datasets available, other common scenarios and frequently asked questions.Avoiding SharePoint Sprawl Without Killing Collaboration
SharePoint has become the backbone of collaboration for many organizations. Its flexibility is a blessing—teams can create sites, share documents, and manage projects with ease. But without governance, that same flexibility can quickly turn into SharePoint sprawl: a maze of redundant sites, duplicated files, and forgotten content that frustrates users and undermines productivity. The challenge is clear: how do you prevent sprawl without choking the collaboration SharePoint was designed to enable? Let’s break it down. https://dellenny.com/avoiding-sharepoint-sprawl-without-killing-collaboration/
Standard Operating Procedures in OneNote - Best Method?
Hi, I've been in business for over 18 years, with 6 employees. We have over 300 policies and procedures that have been written and rewritten. They have always been stored on our Sharepoint server in a regular file folder structure that syncs to our computers. Because of it, nobody uses them for they are difficult to find. Sometimes you don't know the name of what you're looking for, other times its an SOP that could be under production or finance. The system has just never worked. I'm currently implementing a system in OneNote. I have it set up where our 9 primary areas are all tabs. There then exists sections for checklists, specific procedures, and then one large 20-30 page manual for that department that discusses in detail everything that needs to be known. An example is in the 23-page Marketing Manual, there are five paragraphs explaining what brand colors are, why they are important, and why we can't stray from them. It then has a few links to reference other documents, one of them is our Branding Sheet that is a Word document, stored inside OneNote. OneNote is also great because it's desktop software that each of our computers has, every single document can be searched at once, you can utilize links to any part that you'd like, you can utilize tags, and you can store the referenced document inside OneNote (so I don't have to deal with somebody changing the file name or somehow breaking the link to the server. I haven't released it yet, but my employees say they would use it if it were easy. As I'm slowly going through and entering the SOPs into OneNote, I'm finding minor issues with my system in OneNote The formatting is VERY limited. So making a great SOP is not as easy as it is in Word Once I have everything in there, I dont think I can get it back out in an editable fashion. I can print the .pdf but it's not like it's a Word document that can be moved around You can't really set permissions on it. I can lock pages, which would work, but I'd prefer permission on different areas Getting everything in there is going to be challenging enough, then I have to go back and link everything. Before I spend too much time organizing these SOPs and copy/pasting them into OneNote, I was hoping that somebody has gone down this road before and can either advise me away from OneNote to another product or offer advice as to why I should keep going down my path. Thanks in advance. AaronWhat to Do When SharePoint Search Doesn’t Return the Right Results
SharePoint search is one of the platform’s most powerful features—when it works as expected. But many organizations face a common frustration: search results that don’t seem accurate, complete, or relevant. If your users are struggling to find what they need, it can quickly undermine adoption and productivity. The good news? Most search issues can be diagnosed and fixed with the right approach. Here’s a practical guide to troubleshooting when SharePoint search isn’t returning the right results. https://dellenny.com/what-to-do-when-sharepoint-search-doesnt-return-the-right-results/Introduction to SharePoint Agents AI-Powered Automation for Smarter Workflows
Microsoft continues to innovate in the world of enterprise collaboration, and the latest addition to the SharePoint ecosystem—SharePoint Agents—is set to revolutionize the way organizations manage content, automate tasks, and enhance productivity. With AI-driven capabilities, SharePoint Agents bring a new level of intelligence and automation to SharePoint environments, helping businesses work smarter and faster. https://dellenny.com/introduction-to-sharepoint-agents-ai-powered-automation-for-smarter-workflows/Configure Tenant-Level Sharing Settings for SharePoint and OneDrive
Properly configuring tenant-level sharing settings in Microsoft 365 ensures a secure and seamless collaboration experience in SharePoint and OneDrive. This guide walks you through the steps to configure these settings while maintaining security and compliance. https://dellenny.com/configure-tenant-level-sharing-settings-for-sharepoint-and-onedrive/
