Office 365 licenses

Question

Hi

Is there a way to add a data source into Excel to get current users with office 365 licenses assigned?
I can do this manually by just exporting a list or running the power shell command would would like something in excel that I can refresh.

Answer 1

@Carl van Eeden ,

As I understand your query , you are looking to get details of users from within excel which gets refreshed automatically so that you do not have to run scripts to get license information for the users manually every time something changes. Unfortunately Microsoft graph does not allow this anymore due to security concerns. Generally when you query the graph API you can granularly define the permission scopes if you register an application to access user data from your tenant using Microsoft Graph . However in case of Odata feed it allows access to all data under a particular endpoint hence it was regarded as a lapse in security and this option was disabled. At this point you would have to use powershell in order to manually get list of users and associated licenses as far as I know. You may not be able to use excel for this task due to security and compliance reasons as explained. The following is the error that you would see while trying to connect to Odata feed .

Hope the information clarified your query . Should you have any further query , do let us know and we will be happy to help you further.

Thank you .

----------------------------------------------------------------------------------------------------------------------------------------------------------

• Please don't forget to click on whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
• Want a reminder to come back and check responses? Here is how to subscribe to a notification
• If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators