Can you restrict delete permissions to specific users in the Import Export PowerTool?

The Import Export PowerTool does not provide a setting that locks the delete function for individual named users. This is a completely free app from Insight Works for Business Central. Delete access is governed in two layers instead: a global setup option inside the tool, and each user’s underlying Microsoft Dynamics 365 Business Central permissions on the tables being changed. By combining these layers you can control who is able to delete data and what they are allowed to delete.

How delete access is controlled in the tool

The Import Export PowerTool setup page includes an option that determines whether delete operations are allowed at all, blocked entirely, or permitted only after an enhanced confirmation step. This setting applies globally to everyone who uses the tool rather than to specific users. If you set the delete option to no access, no one can delete data through the tool until an administrator changes the setting back. The enhanced confirmation choice adds a prompt that requires the operator to type a confirmation value before the deletion runs, which gives people a moment to reconsider before removing records.

Per user control comes from Business Central permissions

Although the tool has no per user delete switch, it respects the standard Business Central permission model on every table. A user can only delete records in a table if their assigned permission sets grant delete rights on that table. If someone has no delete permission for sales lines, for example, they cannot delete sales lines through the Import Export PowerTool either. In practice this means you achieve user level control by managing each person’s Business Central permission sets, not through a setting inside the tool.

The two permission sets the tool provides

The tool ships with two permission sets, a manager set and a user set. The manager set can edit the setup page, including the delete option and access to protected tables. The user set can run the tool but cannot change any of those settings. Assigning the user set to operators and reserving the manager set for administrators keeps configuration control with a small group, even though the delete allowance itself remains global.

A practical approach to limiting deletions

For environments where only certain people should delete data, a reliable pattern is to grant delete permissions on the relevant tables only to those individuals in Business Central, assign everyone else the user permission set, and turn on the enhanced confirmation option so that any deletion requires a deliberate confirmation. This combination limits who can delete, restricts what they can delete based on table permissions, and adds a final safeguard against accidental mass deletions. Because the tool can reach protected ledger tables such as item ledger entries when access is enabled, this layered control is especially important for sensitive data.

Related Tools

Import Export PowerTool is the Insight Works app for high speed import, export, update, and delete operations across Business Central tables. Its setup page and two permission sets are where you manage whether deletions are allowed and who can configure the tool.

Deleting data is powerful and not easily reversed, so plan your permission model before opening the tool to a wider group. There is no individual user delete lock inside the tool, but combining Business Central table permissions, the user permission set, and the enhanced confirmation option gives you effective and granular control over who can delete data and what they can remove.