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

Notifications

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

I have the same question (0)
  • Suggested answer
    Carolina Mogas Profile Picture
    Carolina Mogas 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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
Tom_Gioielli Profile Picture

Tom_Gioielli 70 Super User 2025 Season 2

#2
Gerardo Rentería García Profile Picture

Gerardo Rentería Ga... 33 Most Valuable Professional

#3
Daniyal Khaleel Profile Picture

Daniyal Khaleel 32 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

Hide selecting Contact for potential customer when creating quote

Product updates

Dynamics 365 release plans