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

Export Users along with their assigned licenses

(7) Share

Report

Posted on by peter fun

739

how to export a list of users along with their licenses assigned in business central

Categories:

Dynamics 365 Business Central

Microsoft Dynamics RMS

Dynamics 365 Business Central migration

Microsoft Dynamics NAV

I have the same question (0)

All responses (8)

Answers (0)

Suggested answer

Ramesh Kumar 7,547 Super User 2026 Season 1 on at

Like (4)

Report
Copy link

Link copied!

Hi,

For Business Central License user list. Best place is M365 Admin center.

https://learn.microsoft.com/en-ca/dynamics365/business-central/admin-access-with-m365-license-setup

https://www.youtube.com/watch?v=B-EugJ94de4&ab_channel=TheDynamicsExplorer

Thanks

Ramesh

Was this reply helpful? Yes No
Suggested answer

Mansi Soni 8,951 Super User 2026 Season 1 on at

Like (6)

Report
Copy link

Link copied!

Hello @peter fun,

In Business Central, to export a list of users along with their assigned licenses (or permission sets), go to Users page (Users), then use the Permissions action to view each user’s assigned permission sets (which reflect license access). Use Open in Excel or Edit in Excel to export the list. Note that Business Central itself does not show Microsoft 365 license assignments those must be checked in the Microsoft 365 Admin Center under Users > Active users > Licenses. So, combine both sources if you need full visibility.

Additionally hope this resources will also give some hints
https://gcit.com.au/knowledge-base/export-list-office-365-users-licenses-customer-tenants-delegated-administration/
https://answers.microsoft.com/en-us/msoffice/forum/all/export-microsoft-office-license-of-users/283580f7-793d-4e81-bf2c-849bc464465c

Hope this answer will help you!

Regards,
Mansi Soni

Was this reply helpful? Yes No
Benjamin Lillebrohus 34 on at

Like (5)

Report
Copy link

Link copied!

Yun Zhu is referencing how to do exactly that in the post below:

https://community.dynamics.com/forums/thread/details/?threadid=d9c4883e-4883-4bf0-bd10-66df9dd28d27

The direct link to Yun Zhu's article is this:

https://yzhums.com/26251/

Please give props to Yun Zhu, as this is not my work, only a reference.

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 99,055 Super User 2026 Season 1 on at

Like (4)

Report
Copy link

Link copied!

Thanks Benjamin for the quote, and hopefully the information below gives you some hints as well.

Dynamics 365 Business Central: How to list all permissions (all users with permission sets or all permission sets with permissions…)

https://yzhums.com/8417/

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

Jeffrey Bulanadi 9,112 Super User 2026 Season 1 on at

Like (3)

Report
Copy link

Link copied!
Hi,

Exporting users with their assigned licenses in BC isn’t natively exposed through standard pages, since license data is managed via Microsoft 365 and only partially reflected inside BC.

Here’s what’s possible:

You can open the Users page in BC and run Update Users from Microsoft 365 to refresh the license-related data. While it doesn’t show license types directly, you’ll get synced user information tied to permission sets and groups.

License assignments are stored in a hidden internal table called User Plan, which you can surface using Query 774 “Users in Plans”. To view this, append ?query=774 to your BC environment URL, then export the results from that query view.

If you need cleaner output, consider building a simple list page referencing Query 774 — showing User Name, Plan Name, and Status. Many admins use this for auditing license usage without leaving BC.

For full licensing details, your best option is the Microsoft 365 Admin Center → go to Billing → Licenses → select the license → choose Export Users to download a full list.

Helpful references:

Create users according to licenses – Microsoft Learn
Licensing in BC – Microsoft Learn
View licensed users using Query 774 – Dynamics 365 Lab
Export users from Microsoft 365 Admin Center – Microsoft Docs
Exporting users and licenses via PowerShell – Microsoft Community

If you find this helpful, feel free to mark this as the suggested or verified answer.

Cheers
Jeffrey

Was this reply helpful? Yes No
Suggested answer

Sohail Ahmed 11,169 Super User 2026 Season 1 on at

Like (3)

Report
Copy link

Link copied!

To export a list of users along with their assigned licenses in Business Central (SaaS):

Steps:

1. Go to: Users page in Business Central (Search 🔍 > Users).

2. Use the “Open in Excel” or “Share > Open in Excel” feature to export the user list.

3. The “License Type” column will show each user’s license (e.g., Full, Team Member, External).

> Note: If you need additional license assignment info from Microsoft 365 (e.g., Essentials, Premium), use Microsoft 365 Admin Center or PowerShell.

✅ Mark this answer as verified if it helps you.

Was this reply helpful? Yes No
Suggested answer

Andrés Arias 5,166 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

Hello,

The following options might help:

- In Busines Central Users and Open in Excel to be able to display the License Type.
- In the Admin Center of Microsoft 365, Users -- Active user and view the licenses.

I hope you can help.

Regards,

Andres

Was this reply helpful? Yes No
Suggested answer

Khushbu Rajvi. 22,128 Super User 2026 Season 1 on at

Like (3)

Report
Copy link

Link copied!

Hope this helps as well: Business Central short video: Get and export a list of users with licenses (Users in Plans)

Was this reply helpful? Yes No