web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Dataverse - Cleaning u...
Power Apps
Unanswered

Dataverse - Cleaning up Storage

(0) ShareShare
ReportReport
Posted on by 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.

I have the same question (0)
  • velegandla Profile Picture
    204 Moderator on at

    @angelatrolio 

    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. 

     

    ====================================================

    https://www.linkedin.com/in/devendravelegandla/ 

  • angelatrolio Profile Picture
    26 on at

    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?

  • velegandla Profile Picture
    204 Moderator on at

    @angelatrolio 

    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.

     

    Velegandla_0-1704253818926.png

     

    Velegandla_1-1704253870743.png

     

    ====================================================

    If this response helped you in any way, please give kudos by clicking the 'Thumbs Up'/'Like' button and/or marking it as an 'Accepted Solution'. This helps others by providing a quick way to identify likely solutions to their issues.
     

    https://www.linkedin.com/in/devendravelegandla/ 

  • angelatrolio Profile Picture
    26 on at

    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?

  • velegandla Profile Picture
    204 Moderator on at

    @angelatrolio 

    That is correct. Please see the documentation from MSDN.

    https://learn.microsoft.com/en-us/power-apps/developer/data-platform/webapi/reference/msdyn_aibfileattacheddata?view=dataverse-latest 

     

    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.

    Velegandla_0-1704259086665.png

     

    ====================================================

    If this response helped you in any way, please give kudos by clicking the 'Thumbs Up'/'Like' button and/or marking it as an 'Accepted Solution'. This helps others by providing a quick way to identify likely solutions to their issues.
     

    https://www.linkedin.com/in/devendravelegandla/ 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
Valantis Profile Picture

Valantis 431

#2
WarrenBelz Profile Picture

WarrenBelz 360 Most Valuable Professional

#3
Kalathiya Profile Picture

Kalathiya 280 Super User 2026 Season 1

Last 30 days Overall leaderboard