You’re offline. This is a read only version of the page.
26
Hi,
I work at an organisation and currently looking into cleaning up their storage, as we are approaching capacity limit. I was wondering if there is any clear way to find out what tables are using the most storage, power apps or power automate. We are not using dataverse for CRM purposes but moreso, Power Platform and data management.
Thanks,
Angela.
That is correct. Please see the documentation from MSDN.
You might need to look at the number of solutions built using AI Builder. This would help in what causing the table size then decide on what needs to be done.
For AI Builder report, you need to download it from capacity section to evaluate what was created by whom.
====================================================
Excellent, thank you so much. Do you know if: msdyn_AIBFileAttachedDataBase is related to the AI Builder. Is there any way to reduce this table?
Click on details icon for each environment from capacity https://admin.powerplatform.microsoft.com/resources/capacity#environments, you can download the list of tables with size.
====================================================
Thank you. Is there any automated ways to check all the tables or does it need to be done manually and assess how many records are in each table?
You need to start at environment level to find the usage of database size, file size and log size.
https://admin.powerplatform.microsoft.com/resources/capacity#environments
Once you know the environment then look at the tables in each environment which got most number of records and then plan to archive/delete.
make sure to do the analysis then depends on usage you might need to communicate with your business, change management which include rollback options and then actual implementation of the change.
====================================================
#1
Michael E. Gernaey
9
Super User 2025 Season 1
#2
bscarlavai33
5
Super User 2025 Season 1
#3
getsplash
2
Share
Report
All responses (
Answers (
