Forum Discussion
Excel access to Graph API (InTune Auditing)
Hello there!
I wonder if someone can help.
We are attempting to pull some data from ms graph into an Excel spreadsheet using the 'odata' option. I am getting permission denied errors.
Access to the resource is forbidden.
From the Graph explorer site I seem to be able to access all the data I need.. but the odata option doesnt seem to work for me.
Do I need any of these permissions below?
If so where are they set?
https://learn.microsoft.com/en-us/graph/permissions-reference
DeviceManagementApps.Read.All
DeviceManagementConfiguration.Read.All
DeviceManagementManagedDevices.Read.All
DeviceManagementRBAC.Read.All
DeviceManagementServiceConfig.Read.All
Thankyou!
MNC
1 Reply
- MonkeyNutCharlieCopper Contributor
I have found this snippet - Mentions that this method of connection doesn't work anymore.
https://stackoverflow.com/questions/52443741/cant-access-ms-graph-from-excel-odata.
I wonder what the alternative would be?