Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I am looking to create a list that contains all the users and their assigned licenses in a tenent. Has someone done this before?
User | License | Fee |
User A | E3 | 65 |
User B | F1 |
Thanks,
Isaac
Is that table the desired outcome (if so, please post the original data too) or is that the original data (in which case we need to see the desired outcome)?
My desired outcome is to take the number of users and based on licenses show how much they are being charged. Unfortutnely, clients keep on asking for licenses without any concern for cost. This will make it transparent. All I require is the number of users and license type. I would address the fees etc via a calculation in powerbi.
I think I may need to clarify.
I managed a CSP and want to report on the license consumption per tenant, for example how many users use E3 vs F1. And then provide a list of the users with the licenses type.
bump.
How can powerBI pull the amount of users and licenses from my CSP subscriptions?
I found a powershell that provides the list of active subscriptions. This is what I am looking for in Phase 1.
Then I found another script that finds the users and who is using what.
This is what I am trying to do in powerbi. I would like to know if there a native way, without powershell, to get this information so I can make a graph on the subscription amount and a table listing the users with subscription.
yes, I would like to create a table with the users that are in O365 with their license type. The data is purely whatever is in O365 on my partner.microsoft.com site.
I think I could pull it from ITGLUE following https://community.powerbi.com/t5/Developer/Connecting-Power-BI-to-a-Web-Service/td-p/710697
However, I am having issues with what the API URL Should be.
Hi @Anonymous ,
I think Azure portal can help achieve what you need,and there 's no need to use ITGLUE.
Here is the reference.
https://docs.microsoft.com/en-us/power-bi/admin/service-admin-manage-licenses
I know I can check it from the portal. However, I would like to create a site where Clients see their tickets, and the amount of accounts. I would use a Calc to multiply their # of users with the support fee. Hence, it can only be done via PowerBI.
The link does not show how to import users and licenses from my CSP into PowerBI.
User | Count |
---|---|
141 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
123 | |
101 | |
71 | |
61 |