Forum Discussion

PrathyushaT's avatar
PrathyushaT
Frequent Visitor
5 months ago
Solved

Fetch licences information

How to fetch list of  all users who are having power bi free, pro , Premium 

 

Need Help
  • v-pnaroju-msft's avatar
    v-pnaroju-msft
    5 months ago

    Thankyou, grazitti_sapna for your response.

    Hi PrathyushaT,

    Based on our understanding, Power BI licensing is managed through Microsoft Entra ID or Microsoft 365 licensing. Therefore, when exporting users from the Microsoft 365 Admin Center, you may observe bundle licenses such as Microsoft 365 E5 or Microsoft Fabric Free, rather than direct labels like Power BI Pro or Power BI Premium. For example, Microsoft 365 E5 includes Power BI Pro, and Microsoft Fabric Free corresponds to the Free Power BI license, which is why the export does not display Pro, Free, or Premium as separate columns.

    Please note that Power BI Premium capacity is assigned to workspaces, not to individual users. Consequently, users accessing content hosted in Premium capacity may still appear as Free users from a licensing perspective.

    One possible approach is to query the tenant licensing information through Microsoft Graph, since license assignments are stored in Entra ID rather than in the Power BI service itself.

    For more information, kindly refer to the links provided below:
    Power BI service features by license type - Power BI | Microsoft Learn
    List users - Microsoft Graph v1.0 | Microsoft Learn
    List subscribedSkus - Microsoft Graph v1.0 | Microsoft Learn
    List licenseDetails - Microsoft Graph v1.0 | Microsoft Learn

    We hope the information above assists in resolving the issue. Should you have any further queries, please feel free to contact the Microsoft Fabric community.

    Thank you.

5 Replies

  • grazitti_sapna's avatar
    grazitti_sapna
    Super User
    5 months ago

    hi PrathyushaT,

     

    You need admin access to get these details

     

    In microsoft 365

    1. Go to https://admin.microsoft.com

    2. Navigate to
      Users → Active Users

    3. Click Export users

    You will get an Excel/CSV file containing:

    • User Name

    • Email

    • License assigned

    You can also get the same using Power BI rest API (necessary permissions (Admin))

    GET https://api.powerbi.com/v1.0/myorg/admin/users

     

    🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.
    💡 Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.
    🎖 As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.
    🔗 Curious to explore more? [Discover here].
    Let’s keep building smarter solutions together!

    • PrathyushaT's avatar
      PrathyushaT
      Frequent Visitor
      5 months ago

      Hi grazitti_sapna 

      Thank you for the response 

      I have already explored the microsoft 365,i am able to export the listbut in licence type in do get Microsoft fabric free and microsoft 365 e5. But i need a list like pro pu and premium 

       

      Regarding the rest api what is the rest api name can you share the document

       

      Thank you 

  • v-pnaroju-msft's avatar
    v-pnaroju-msft
    Community Support
    5 months ago

    Thankyou, grazitti_sapna for your response.

    Hi PrathyushaT,

    Based on our understanding, Power BI licensing is managed through Microsoft Entra ID or Microsoft 365 licensing. Therefore, when exporting users from the Microsoft 365 Admin Center, you may observe bundle licenses such as Microsoft 365 E5 or Microsoft Fabric Free, rather than direct labels like Power BI Pro or Power BI Premium. For example, Microsoft 365 E5 includes Power BI Pro, and Microsoft Fabric Free corresponds to the Free Power BI license, which is why the export does not display Pro, Free, or Premium as separate columns.

    Please note that Power BI Premium capacity is assigned to workspaces, not to individual users. Consequently, users accessing content hosted in Premium capacity may still appear as Free users from a licensing perspective.

    One possible approach is to query the tenant licensing information through Microsoft Graph, since license assignments are stored in Entra ID rather than in the Power BI service itself.

    For more information, kindly refer to the links provided below:
    Power BI service features by license type - Power BI | Microsoft Learn
    List users - Microsoft Graph v1.0 | Microsoft Learn
    List subscribedSkus - Microsoft Graph v1.0 | Microsoft Learn
    List licenseDetails - Microsoft Graph v1.0 | Microsoft Learn

    We hope the information above assists in resolving the issue. Should you have any further queries, please feel free to contact the Microsoft Fabric community.

    Thank you.

  • v-pnaroju-msft's avatar
    v-pnaroju-msft
    Community Support
    5 months ago

    Hi PrathyushaT,

    We would like to follow up and see whether the details we shared have resolved your problem. If you need any more assistance, please feel free to connect with the Microsoft Fabric community.

    Thank you.

  • v-pnaroju-msft's avatar
    v-pnaroju-msft
    Community Support
    5 months ago

    Hi PrathyushaT,

    We are following up to see if what we shared solved your issue. If you need more support, please reach out to the Microsoft Fabric community.

    Thank you.