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.

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