PowerBI / Intune onPremisesExtensionAttributes

[algorton]

Good morning

I am connecting to InTune using the OData connection to the Data Warehouse, however, I cannot find the extended user attributes. Using Graph I can recover these using something similar to that below:

Get-MgUser -UserId xxxxxx -Property onPremisesExtensionAttributes | select -ExpandProperty onPremisesExtensionAttributes | select -ExpandProperty ExtensionAttribute10

My question is how do I easily extract these extended user attributes into my PowerBI report? I suspect that I need to connect to the Microsoft Graph to get the data but I am not really sure how to do this. Any good source of information on this topic would be appreciated.

Thanks