Forum Discussion

MonkeyNutCharlie's avatar
MonkeyNutCharlie
Copper Contributor
May 26, 2023

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

  • 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?

Resources