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

Announcements

Check out the Community Spotlight Video Series
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance forum / Deleting Data with Dat...
Finance forum

Deleting Data with Data Management Tool

(0) ShareShare
ReportReport
Posted on by Ruben Heinrich 643

Hi all,

is there a way to use Data Management Framework to actually delete Data?

I tried to upload a empty Excel Sheet, hoping this would do the job, but it didn't. Do i have to hammer in to VS?

My specific scenario is in a testing System, where i want to delete all Product Category Assignments. Unfortunately  there is no

Dataset which i could use with Excel Data Connector.

thanks for any ideas.

ruben.

Categories:
Other
I have the same question (0)
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 306,873 Super User 2026 Season 2 on at

    Hi Ruben,

    There is a setting to truncate data before the import, but I don't know if it will really delete records when the sheet only contains headers.

  • Verified answer
    Khushhal Garg Profile Picture
    Khushhal Garg 1,514 on at

    "Truncate entity data" truncates all existing data and imports the data that is in the file. In case file is empty, it doesn't truncate existing data.

    Keep only one record in the file and choose option "Truncate entity data" during import. In this case, it will truncate all existing data and import only one record from file. Then just delete this one record manually from UI.

  • Ruben Heinrich Profile Picture
    Ruben Heinrich 643 on at

    Works!

    Thank you a lot!

  • Community Member Profile Picture
    Community Member on at

    Hello,

    Sounds like you have been able to get "Truncate data" working? I am trying to delete existing data, ex Payment Terms. I export all data into CSV file, delete all the lines except for 1, then reimport the CSV file. I would expect if I import that all the data in the payment terms form would be deleted except only see that 1 line in my payment terms; however  nothing is happening.  Thoughts?

    Thanks,

    Kellen

  • Dave C Eng Profile Picture
    Dave C Eng on at

    A little trick If you add a line with an error e.g a reference field with an invalid value it will truncate the entity and fail to import the one row leaving nothing to cleanup via the UI

  • Dave C Eng Profile Picture
    Dave C Eng on at

    Are you selecting the trucate entity option?

  • Akash12345 Profile Picture
    Akash12345 5 on at

    I did the same try for customer master data using custCustomerV3Entity but it didn't work out (records are not deleted from the entity).

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

Check out the Community Spotlight Video Series

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard > Finance

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans