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. Sample Dashboards and Reports
Here are samples of the reports and dashboards included in the Power BI Template.
Note: These dashboards are provided as examples or starting point, which you can modify as needed. There are many more ways to visualize the data in these datasets.
8. Conclusion
I hope this provides 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
