Skip to content
Import Export PowerTool app iconImport Export PowerToolControl and extension

Permission Sets for Microsoft Dynamics 365 Business Central

A tool that can update and delete data in bulk needs clear limits on who can do what. Import Export PowerTool uses two permission sets, a manager set that can change the setup page and a user set that cannot, and it works within each user's existing Business Central table permissions. This is a completely free app from Insight Works for Business Central.

How Permission sets works in Import Export PowerTool

  1. A Business Central administrator assigns the manager and user permission sets.
  2. A manager sets update, delete, change log, and protected table access on the Import Export PowerTool Setup page.
  3. Users run imports, exports, updates, and deletes within those settings and their own table permissions.

Key capabilities

Two permission sets

Assign the manager set to the people who decide how Import Export PowerTool may be used, and the user set to everyone else who runs it.

Setup decides the rules

The setup page sets Update Access, Delete Access, Disable Change Log access, and Protected Tables access. Options include no access and an enhanced confirmation.

Existing permissions respected

Import Export PowerTool cannot be used to change or delete records a user could not otherwise change or delete.

Not tied to license tier

Access to the app is controlled by its permission sets rather than by Business Central license tier.

See Permission sets on screen

Real screens from Import Export PowerTool, shown with demo data.

Details that matter on the floor

Built for specialists

Import Export PowerTool is built for consultants, developers, and administrators. Everyday users can use it with care, with the user permission set and no protected table access.

No new capability

The tool grants nothing beyond what a user's Business Central permissions allow; it makes permitted work faster to do.

Who uses Permission sets

Business Central administrators

Assign permission sets and set access on the setup page.

IT project managers

Decide who on a project may run updates and deletes.

Questions about Permission sets

Who can change the Import Export PowerTool settings?

Only users with the manager permission set. The user permission set cannot change setup.

Can Import Export PowerTool bypass Business Central permissions?

No. It works within each user's existing Business Central table permissions.

Which Business Central license does a user need?

Each user needs a Business Central license, and Import Export PowerTool is free on Business Central online. Licensing depends on your setup; see the licensing FAQ.

Import Export PowerTool app icon

Part of Import Export PowerTool

Import, export, update, and delete Business Central data in bulk, for data migration and ongoing data management.

Have a question about Permission sets?

Send us a note and the Import Export PowerTool team will reply by email. Ready to plan a rollout? Contact your Microsoft Partner.

Ask a product question

Product Questions