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

Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Customer experience | Sales, Customer Insights,... / Sales insights tables ...
Customer experience | Sales, Customer Insights,...
Suggested Answer

Sales insights tables (email-analytics and activityparty-analytics) consume too much space

(0) ShareShare
ReportReport
Posted on by genesario 25

Hi all,

Some time ago we turned on Sales Insights (basic version) on our production instance, and on the next day I saw two new tables email-analytics and activityparty-analytics, and they were 120Gb total.

I believe they contain some data for sales insights.
We indeed have lots(millions) of emails, 99% of it is Customer Support related messages, which we definitely do not need to to analyze and deleting them is not an option.

I didn't find any switches or settings to change such behaviour, or turn off Sales Insights.
I only disabled all assistant cards.


Any thoughts on how to clean the database?
1222.2020_2D00_11_2D00_09-09_5F00_34_5F00_23_2D00_Window.png

2570.2020_2D00_11_2D00_09-09_5F00_34_5F00_14_2D00_Window.png

I have the same question (0)
  • Suggested answer
    Carolina Mogas Profile Picture
    Carolina Mogas Microsoft Employee on at

    Hello Andrei,

    Email-Analytics and Activityparty-Analytics are tables which will be created after Sales Insights is deployed in an environment.

    You can verify what are the entities currently enabled for Azure Data Lake Services integration by accessing the following entity through an API request:

    https://[organization URI]/api/data/v9.0/entityanalyticsconfigs

    All entities retrieved in this request that contain "isenabledforadls":true can potentially create a table for Analytics.

    In order to reduce the consumption, the solution that contains this functionality should be uninstalled (in this case Sales Insights) and the tables should be cleaned up automatically in 48h.

    However, before proceeding with this action, please raise a case with Technical Support so we can investigate this further for your specific environments.

    Thank you!

    Carolina

    Thank you for using Microsoft Dynamics 365 Communities!

    Carolina Mogas, Support Engineer
    Dynamics 365

  • Priyesh Profile Picture
    Priyesh 7,396 User Group Leader on at

    Hi,

    Pardon me for bringing this thread back.

    I'm having similar issues in seeing the File storage ballooning because of the <entity>-Analytics table and not finding where this data is actually stored.

    Wanted to confirm if deleting the solution is the only way? In my case, I can't see any Insights application installed on the environment.

    Kindly advise. :)

    Thanks in advance!

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

News and Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight

Quick Links

Season of Sharing Community Challenge Launch!

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

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
Hamza H Profile Picture

Hamza H 142 Super User 2026 Season 1

#2
ManoVerse Profile Picture

ManoVerse 131 Super User 2026 Season 1

#3
Nagaraju_Matta Profile Picture

Nagaraju_Matta 128

Last 30 days Overall leaderboard

Featured topics

Hide selecting Contact for potential customer when creating quote

Product updates

Dynamics 365 release plans