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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested Answer

BC User List with License Assignment

(5) ShareShare
ReportReport
Posted on by 1,112
I am trying to generate a user list with license assignments (Business Central Essentials/Teams Member/External Accountant, etc...)
 
I do not have access to the customer's M365 environment.  That said, I can view their users in our Microsoft Partner Center and in Business Central.  But from PartnerCenter I cannot export or generate a list with the license assignments, and in Business Central I can export the users, but I do not see the assigned license information.  I've also looked at the underlying tables under configuration packages.  
 
Is there any other way to view the users with their license assignments in either BC or in Partner Center?  Please advise.  Look forward to a response.
I have the same question (0)
  • Suggested answer
    Pallavi Phade Profile Picture
    5,634 Super User 2026 Season 1 on at
    Namaste @SL_GP_BC_123
     
    Can you check Table "User plan " Will this infromation help .
     
     
     
    Else there is no direct provision . Or have to check for admin center API
     
     
    Warm Regards
    Pallavi Phade
  • Suggested answer
    Aman Kakkar Profile Picture
    3,526 Super User 2026 Season 1 on at
    Hi,
     
    You can use query 774 “Users in Plans”.
     
     
    In your Business Central URL, after sandbox name run this query -
     
     
    Do mark it as verified if this helps.
    Aman K
  • Suggested answer
    OussamaSabbouh Profile Picture
    16,310 Super User 2026 Season 1 on at
    Hello,
     
    There is no way in BC or Partner Center to export users with their assigned BC licenses unless you have access to the customer’s Microsoft 365 Admin Center.
     
    BC → shows users but not their license type.
     
    Partner Center → shows subscriptions, but not a per-user license list.
     
    The only options are:
     
    1. Customer exports it from Microsoft 365 Admin Center.
     
     
    2. You query Microsoft Graph API (needs customer consent).
     
     
    That’s it — BC itself cannot display license assignments.
     
    Regards,
    Oussama Sabbouh
  • Gerardo Rentería García Profile Picture
    26,794 Most Valuable Professional on at

    Hi, good day
    I hope this can help you, and give you some hints.

    Export Users along with their assigned licenses

    Best Regards
    Gerardo

  • Suggested answer
    Jainam M. Kothari Profile Picture
    16,530 Super User 2026 Season 1 on at
    Hello,
     
    Neither Business Central nor Partner Center provides a built-in way to export users with their license assignments; Business Central only shows internal user setup, and Partner Center displays licenses but lacks export functionality.
     
    You can export from the Microsoft 365 Admin Center → Users → Active Users → Export Users, which includes license details.
  • Suggested answer
    Rishabh Kanaskar Profile Picture
    6,227 Super User 2026 Season 1 on at
    Hi,
     
    I can't find a way to view license assignments directly in Business Central because it does not store Microsoft 365 license details. Partner Center also does not provide an export option for license assignments through the UI. 
    If you have delegated admin rights, you can run PowerShell commands to export license details from the customer tenant.
    Without tenant access, you cannot get license assignments from Business Central or Partner Center UI alone.
     
    Thanks
    Rishabh

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,003 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,225 Super User 2026 Season 1

#3
AndrewThomas81 Profile Picture

AndrewThomas81 1,192

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans