Skip to main content

Notifications

Announcements

No record found.

Small and medium business | Business Central, N...
Suggested answer

Exporting Permissions Set from Dynamics NAV to Dynamics 365 Business Central OnPrem or SaaS via RapidStart Unfollow

(0) ShareShare
ReportReport
Posted on by

The procedure to migrate permission sets from old Dynamics NAV to new Dynamics 365 Business Central can only be done via RapidStart. This is because in Dynamics 365 Business Central you can now have User Defined Permission set together with System and Extension based permissions set.

The recommendation is to use a later CU for both releases as we allow export / import from / to two other tables that are now also being used in Dynamics 365 Business Central. These tables are:

  1. Tenant Permission Set
  2. Tenant Permission

In the first table we store the name of the Permission Set. In the second table we store the actual permission.

Procedure:

  1. start up Dynamics NAV 201x and search for Configuration Packages (can be WinClient or WebClient)

NOTE: for the procedure, we expect that there is a custom permission set called "Permission Set to be Migrated" with ID PSTBM with some permissions added to a few tables.

  1. press New to create a new one

pastedimage1589531888446v15.png

NOTE: for simplicity you can add a table filter on both tables via Table, Filter so that only the permission set we did create for this purpose is added to the package

pastedimage1589531911566v16.png

  1. from the Actions menu in the Ribbon, select Export to Excel
  2. save the file locally and open it and leave it open
  3. now go to Dynamics 365 Business Central (for this test, I am using BC150 OnPrem) and perform the same procedure; this time we use two different tables
  • Tenant Permission Set
  • Permission Set

pastedimage1589531961121v17.png

  1. from the Package menu, select Export to Excel and open the file

NOTE: for simplicity you can add a table filter on both tables via Table, Filter so we only export it as a template

pastedimage1589531998587v18.png

Results are like this:

pastedimage1589532081438v20.png

7. Now merge the information

Results are like this:

pastedimage1589532104227v21.png

8. User-Defined Permissions have an App ID of zeros which is the missing part:

Results are like this:

pastedimage1589532244690v25.png

 9. save the file and import the package via Package, Import from Excel

NOTE: since you did create the package as a template, you may have to remove the created package first before you re-import the modified Excel sheet again to avoid errors

Result are like this:

pastedimage1589532301260v27.png

10. press Process, Apply Package

Result are like this:

pastedimage1589532334288v28.png

You have now successfully imported a permission set from Dynamics NAV into Dynamics 365 Business Central that can be modified if needed.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Exporting Permissions Set from Dynamics NAV to Dynamics 365 Business Central OnPrem or SaaS via RapidStart Unfollow

    Choose the Lightbulb that opens the Tell Me feature icon, enter Configuration Packages, and then choose the related link.

    Choose the New action.

    On the General FastTab, fill in the fields as appropriate. Hover over a field to read a short description.

    To exclude the configuration questionnaires, configuration templates, and configuration worksheet tables from the package, select the Exclude Configuration Tables check box. Otherwise, these tables will be added to the list of package tables automatically when you export the package.

    Choose the Get Tables action. The Get Package Tables batch job page opens.

    Choose the Select Tables field. The Config. Selection page opens.

    Choose the Select All action to add all tables to the package, or select the Selected check box for each table in the list that you want to add.

    Choose the OK button. The count of tables that you have selected is indicated in the Select Tables field. Specify additional options, and then choose the OK button. Business Central tables are added to the lines of the Config. Package page.

    Admin

    Apps4Rent | O365CloudExperts

  • Suggested answer
    Marco Mels Profile Picture
    Marco Mels on at
    RE: Exporting Permissions Set from Dynamics NAV to Dynamics 365 Business Central OnPrem or SaaS via RapidStart Unfollow

    Not a question.

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,234 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,994 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans