SharePoint sites and data enterprise cost allocation

From an admin standpoint, managing cost centers and cost allocation to SharePoint Online can be challenging, as there is no native feature in SharePoint Online to add a custom column in the SharePoint admin center to the sites. However, there are some possible workarounds that I've used that you can try, such as:

- Using PowerShell scripts to create and update site properties with cost center information, and then use the SharePoint Online Management Shell cmdlets to get site usage reports and filter by site properties.

Then use Microsoft Graph API to access and update site properties with cost center information, and then use the Microsoft Graph reports API to get site usage reports and filter by site properties. You can then display this in a PowerBI report.

If you don't want to go this route then third party is your only option to provide cost management features for SharePoint Online, I've used such Rencore, ShareGate, AvePoint, before at clients. These tools can help you track and allocate costs by site, site collection, or tenant level, and provide reports and dashboards for cost analysis and optimization.

I hope this answer helps you with your query. If you have any further questions, please feel free to ask. 🙂