Capacity Template – MGDC for SharePoint

1. Capacity scenario

One of the most common scenarios for Microsoft Graph Data Connect for SharePoint is capacity. This scenario is about determining how much storage your tenant uses and understanding the life cycle of your SharePoint site.

The primary MGDC data sets for this scenario are SharePoint sites and SharePoint files. If you are unfamiliar with these datasets, you can find details in the schema definition below. SharePointSites_v1 and SharePointFiles_v1.

2. Capacity template

To help you use these datasets, the team worked on capacity templates. These include:

• set of instructions
• ARM template
• Azure Synapse pipeline template
• Power BI templates

Let’s investigate them one by one.

3. Instructions

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

Instructions for each of the above can be found here: https://github.com/microsoftgraph/dataconnect-solutions/tree/main/ARMTemplates/Archimedes%20Capacity….

4. ARM template

Capacity templates include Azure Resource Manager templates that help you set up resource groups, Synapse workspaces, Spark pools, storage accounts, and storage permissions. Deploy ARM templates to automatically provision those resources.

You can find more information on how to find and deploy ARM templates in the instructions (see Item 3).

5. Pipeline template

Capacity scenarios include pipeline templates that you can use to simplify deployment. If you need to create a pipeline in Azure Synapse, you can use the Synapse Gallery to find pipeline templates.

You can find more information about how to create and run a pipeline in the instructions (see topic 3).

6. Power BI template

The final step is to create a set of reports and dashboards using Power BI. There are Power BI templates available in .PBIT file format. This allows you to quickly transform your data into ready-to-use, pre-built dashboards and reports that you can then customize.

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

7. Conclusion

I hope this has been a good overview of capacity templates. More information about Microsoft Graph Data Connect for SharePoint can be found here: https://aka.ms/SharePointData. Here you can find a lot of details, including a list of available datasets, other common scenarios, and frequently asked questions (FAQs).