1. Capacity Scenario

One of the most common scenarios for Microsoft Graph Data Connect for SharePoint is capacity. This scenario is about knowing how much storage is being used by the tenant and understanding the lifecycle of SharePoint sites.

The main 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 SharePointSites_v1 and SharePointFiles_v1.

2. Capacity Template

To help you use these datasets, the team has worked on a Capacity Template. This includes the following:

A set of instructions
An ARM template
An Azure Synapse pipeline template
A Power BI template

Let’s investigate each one.

3. Instructions

The template comes with a set of instructions with details about registering an application, creating a secret, deploying an ARM template, importing a pipeline template, running the pipeline and creating a Power BI dashboard.

You can find the instructions for each of the items above at https://github.com/microsoftgraph/dataconnect-solutions/tree/main/ARMTemplates/Archimedes%20Capacity%20Scenario.

4. ARM Template

The capacity template includes an Azure Resource Manager template that helps you set up the resource group, Synapse workspace, Spark pool, storage account, and storage permissions. You deploy the ARM template to automatically provision those resources.

You can find details on how to find and deploy the ARM template in the instructions (see item 3).

5. Pipeline Template

The Capacity Scenario includes a pipeline template that you can use to simplify your deployment. In Azure Synapse, when you need to create a pipeline, you can use the Synapse Gallery to find the pipeline template. 

You can find details on how to create and run the pipeline in the instructions (see item 3).

6. Power BI Template

The last step is to create a set of reports and dashboards using Power BI. There is a Power BI template for that, which comes in the form of a .PBIT file. This helps you quickly turn your data into ready-to-use preconfigured dashboards and reports, which you can then customize.

You can find details on how to find and use the Power BI template in the instructions (see item 3).

7. Conclusion

I hope this provided a good overview of the Capacity template. 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.

​Microsoft Tech Community – Latest Blogs –Read More