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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Files storage: F&O "Fi...
Finance | Project Operations, Human Resources, ...
Suggested answer

Files storage: F&O "Financial Analytical table workspace-Analytics" process consuming storage fast

(4) ShareShare
ReportReport
Posted on by MJ-17040615-0 8
Hello everyone,
 
For our dynamics F&O (or AX) application (prod envionment) we have a background "Financial Analytical table workspace-Analytics" process consuming quickly the file storage that we have with Microsoft.
 
We somehow deductedd that it was linked to the "business performance analystics" application that was unwillingly added not so long ago.
Apparently an application that transform raw data into "copied" processed data so we can use it in a structured way from our datalake.
But well we don't have any need for transformed data now, what we need though, is to not reach the file storage threshold.
 
My question here is twofold:
- How do we stop this process? we keep on deleting the application in Prod and it keeps coming back
- How do we delete that transformed data that was generated? we don't have any need for it but we struggle to see where it is stored
 


 
 
Thanks a lot
Categories:
Microsoft Dynamics AX
I have the same question (0)
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 297,485 Super User 2025 Season 2 on at
    Files storage: F&O "Financial Analytical table workspace-Analytics" process consuming storage fast
    @kheimanhso,

    The reply from Holly was most likely created by AI and pasted without any verification. In the meantime, some "AIxperts" got several requests to mention the source and first validate the outcome before pasting incorrect suggestions on the forum. 
  • Suggested answer
    Sohaib Cheema Profile Picture
    Sohaib Cheema 47,821 User Group Leader on at
    Files storage: F&O "Financial Analytical table workspace-Analytics" process consuming storage fast
    This happens due to the BPA logs. At the moment, you have to raise a MS Support request for those to be cleaned or reduced in size.
    I also went through one incident where we decided to uninstall the BPA completely from one of the test systems, as we had many test systems and decided not to have BPA on every test system.
    Please raise a support request with Microsoft.
  • kheimanhso Profile Picture
    kheimanhso 2 on at
    Files storage: F&O "Financial Analytical table workspace-Analytics" process consuming storage fast
    The suggested answer here is getting linked by Copilot as a potential solution and I believe it is based on some LLM hallucination. Can anyone confirm that these steps listed are correct for cleanup? I cannot seem to find any of the recommended license/batch jobs, the data is not in dataverse tables, and the BPA storage is not directly accessible via any data lake storage access, as it is 'black boxed' in the environment's File Storage area. According to Business performance analytics FAQ - Finance | Dynamics 365 | Microsoft Learn it seems like you may need to follow an uninstall script and then still may need MS support to aid with cleanup.
     

    Why does Business performance analytics’ managed data lake storage keep growing, and how is it cleaned up?

    Each time Business performance analytics refreshes, your source data are transformed into files in the Dataverse managed data lake without immediately deleting prior files. Older files are purged automatically after 30 days or earlier if usage hits 50 percent. In earlier releases, staging-table references sometimes blocked file deletion, so transform outputs accumulated until Microsoft engineers manually cleaned up every two weeks. As of the January 2025 update (v2.0.29241185+), those dependencies are removed and added a three day retention policy via the autocleanup flight flag, which regularly clears out old files and dramatically reduces manual intervention.

     Important

    Customers affected by storage capacity growth after updating to Business performance analytics version 2.0.29241185 or later should contact support and request to enable the temporary files cleanup routine for their environment.

    Uninstall

    How do I uninstall Business performance analytics?

    There are two ways to uninstall Business performance analytics: using code-based uninstallation or manual uninstallation. For detailed instructions, see Uninstall Business performance analytics.



    https://learn.microsoft.com/en-us/dynamics365/finance/business-performance-analytics/uninstall-bpa

     
  • Suggested answer
    Holly Huffman Profile Picture
    Holly Huffman 6,520 Super User 2025 Season 2 on at
    Files storage: F&O "Financial Analytical table workspace-Analytics" process consuming storage fast
    Good morning, afternoon, or evening depending on your location!
     
    Based on your description and the insights from available resources, here are some steps to address your concerns:
    Stopping the Process from Reinstalling
    1. Check Installed Solutions:
      • Navigate to System Administration > Setup > License Configuration and verify if the Business Performance Analytics application is listed.
      • If it is enabled, try disabling it to prevent automatic reinstallation.
    2. Remove Scheduled Jobs:
      • Go to System Administration > Batch Jobs and look for any scheduled jobs related to Financial Analytical Table Workspace-Analytics.
      • If found, disable or delete them to stop automatic execution.
    3. Check Environment Settings:
      • If the application keeps reinstalling, it may be tied to Microsoft-managed updates.
      • Contact Microsoft Support to confirm if this feature is part of an enforced update cycle.
    Deleting Transformed Data
    1. Identify Storage Location:
      • The transformed data is likely stored in Azure Data Lake or within Dataverse storage.
      • Check System Administration > Data Management > Storage Reports to locate large datasets.
    2. Remove Unnecessary Data:
      • If stored in Dataverse, use Advanced Find or XRM Toolbox to locate and delete unnecessary records.
      • If stored in Azure Data Lake, access the storage account and manually delete the processed datasets.
    3. Disable Data Processing:
      • If you do not need transformed data, disable the Entity Analytics Config settings to prevent further data generation.
    Hope this helps some!

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

Dynamics 365 Community Calls Return
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Responsible AI policies for the Community

Quick Links

Responsible AI policies

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

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

Congratulations to the August Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Sohaib Cheema Profile Picture

Sohaib Cheema 789 User Group Leader

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 607 Super User 2025 Season 2

#3
Martin Dráb Profile Picture

Martin Dráb 497 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans