Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics 365 | Integration, Dataverse...
Unanswered

[Customer Guide] How to Reduce Consumption of "-Analytics" Tables

(5) ShareShare
ReportReport
Posted on by
     ! Important

This article contains steps on how to remove the capacity consumption of the “-analytics” tables, which involve disabling solution settings and uninstalling solution components. Before proceeding, please make sure that the analytics and insights features are not being used in the environment.

Tables ending in “-Analytics” hold data related with predictive insights and/or analytics dashboards, which are synched from Microsoft Dataverse entities into Azure Data Lake Storage, for each of the following applications:

  • Sales Insights
  • Customer Service Hub
  • Field Service
  • Resource Scheduling Optimization

If one or more of the above solutions is installed in an environment, is possible that one or more tables will be generated to hold the information being produced by the respective functionality. Some examples of the functionalities that utilize the Analytics tables are Relationship Analytics, Predictive lead/opportunity scoring, Sales Insights cards, conversational intelligence.

Table to solution mapping

These are some of the most common tables that are generated for Analytics for each solution. Do note that this is not an exhaustive list and further entities may be added or removed.  

  Customer Service Hub (msdyn_AnalyticsForCS)

  Sales Insights (SalesInsightsMDLConfig)

  Field Service (msdyn_DataInsightsAndAnalyticsForFS)

  Resource Scheduling Optimization (msdyn_DataInsightsAndAnalyticsForRSO)

incident queue resource bookableresourcebooking
incidentresolution systemuser msdyn_priority msdyn_resourcerequirement
subject organization msdyn_routingoptimizationrequest territory
queue account msdyn_routingprofileconfiguration calendarrule
queueitem contact calendar bookableresourcegroup
activitypointer lead msdyn_optimizationrequestsource bookingstatus
systemuser opportunity bookableresource msdyn_bookingtimestamp
appmodule team bookableresourcegroup organization
organization phonecall msdyn_resourcerequirement
email territory
appointment calendarrule
activityparty organization
connection
businessunit
metric
opportunityproduct
product
opportunitysalesprocess
processstage
connectionrole
workflow
gole
role
systemuserroles
msdyn_autocapturesettings
msdyn_autocapturerule
leadtoopportunitysalesprocesses


Step 1 | Confirm which analytics features are enabled

It is possible to confirm which analytics features are enabled for an environment by either checking each individual application and confirm if the analytics and insights is enabled (same steps are the ones mentioned to remove their consumption in the next section), or use the connection to SQL Server Management Studio to retrieve this information.

Please review the public documentation on how to connect to your environment database here and make sure that the TDS endpoint is enabled in Environment Settings in the Power Platform Admin Center.

After connecting to the database, you can execute the following query to retrieve a list of the analytics features available for your specific environment and what is their current status:

SELECT msdyn_datainsightsandanalyticsfeature.createdon,
msdyn_datainsightsandanalyticsfeature.solutionid, solution.friendlyname,
solution.description, msdyn_name, msdyn_provisionstatusname, msdyn_isenabledname
FROM msdyn_datainsightsandanalyticsfeature
JOIN solution
ON msdyn_datainsightsandanalyticsfeature.solutionid = solution.solutionid

Example result:

7824.Screenshot_5F00_3.png

Through this query you can review what is the name of the solution (friendlyname) that includes the analytics features (msdyn_name); if the feature has been provisioned in the environment (msdyn_provisioningstatusname), and what is its current status in the environment (msdyn_isenabledname).

Step 2 | Disable analytics features

     ! Important

Please make sure that the analytics and insights features are not being used before executing any of the following steps. If you wish, at any point, to revert the analytics functionalities for a given environment, you will need to re-enable the historical analytics setting for the respective application. only the setting that was disabled needs to be enabled again.

In order to reduce the capacity consumption of the analytics tables, the respective solution that is connecting to Managed Data Lake needs to be uninstalled from the environment or the analytics capability of the solution needs to be disabled. If there’s an entity that is shared between multiple solutions, you may need to remove both of them in order to cleanup the respective analytics table, otherwise the consumption will remain.

> For Sales Insights

To remove the consumption of Analytics tables created by Sales Insights, the SalesInsights MDL solution needs to be uninstalled from the environment:

8267.pastedimage1612979892567v2.png

At the moment, if any solution or system update is deployed to Sales Insights, the MDL solution will be generated again and the tables may once again be created. The workaround for the time being is to uninstall the MDL solution again, until this behavior is patched, or uninstall SalesInsightsAddOn as well.

> For Customer Service Hub

The analytics and insights capabilities for Customer Service Hub are enabled manually for each environment.

Customers have the option to opt-out of this feature, which will remove all the -Analytics tables dependent on Customer Service Analytics, by following the below steps:

  1. Access Customer Service Hub > Service Management
  2. Scroll on the left side panel to Analytics and Insights and click Settings
  3. Access Customer Service historical analytics (preview)
  4. Disable the feature

6765.Screenshot_5F00_5.png

Make sure that the solution Insights and Analytics for Customer Service historical analysis (msdyn_InsightsAnalyticsCSHistoricalAnalytics) is uninstalled after this setting is disabled.

> For Field Service

The same steps for Customer Service Hub apply to Field Service; as such, in order to disable the consumption of analytics and insights for Field Service, the following steps can be followed:

  1. Access Field Service > Settings
  2. Scroll on the left side panel to Analytics and Insights and click Settings
  3. Access Field Service historical analytics
  4. Disable the feature

8666.Screenshot_5F00_7.png

Make sure that the solution Insights and Analytics for Field Service historical analysis (msdyn_InsightsAnalyticsFSHistoricalAnalytics) is uninstalled after this setting is disabled.

> For Resource Scheduling Optimization

The analytics tables created after the installation of RSO are associated with reporting capabilities for this solution. The previous steps apply to this solution as well:

  1. Access Resource Scheduling Optimization application
  2. Scroll on the left side panel to Settings > Analytics and Insights
  3. Access Resource Scheduling historical analytics
  4. Disable the feature

     6840.Screenshot_5F00_8.png

Step 3 | Monitor the capacity report

Once any of the action plans above are applied to the environment, the “-analytics” tables associated with a particular solution, should be automatically removed between 24h and 48h. If, following this time range, the tables are still present in the capacity report or if you see an entity generated in File Capacity which you are unsure to which solution it belongs to, please raise a support request with Dynamics 365 technical support team.


See also

  • RE: [Customer Guide] How to Reduce Consumption of "-Analytics" Tables

    Very UNCLEAR ...

    Disappointed. I have searched for a month and just found what i was searching for. Hope it will work ...

    + Pour les francais et un peu plus de détails :
    pastedimage1661500519053v1.png

  • LuHao Profile Picture
    LuHao 40,874 on at
    RE: [Customer Guide] How to Reduce Consumption of "-Analytics" Tables

    Thanks for your sharing.

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Congratulations to the January Top 10 leaders!

Check out the January community rock stars...

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,187 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,966 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans