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

Announcements

No record found.

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

  • 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

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
11manish Profile Picture

11manish 109 Super User 2026 Season 2

#2
Syed Aqib Raza Profile Picture

Syed Aqib Raza 88

#3
ParthPatel249 Profile Picture

ParthPatel249 82

Last 30 days Overall leaderboard

Featured topics

Hide selecting Contact for potential customer when creating quote

Product updates

Dynamics 365 release plans