This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(265.6, 32%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETD%3C/text%3E%3C/svg%3E)
Hi, I would like to access Microsoft Intune DW from Azure Data Factory using OData feed. I know that there is existing Power BI connector to Intune, based on OData feed, but I need to have some ETL applied first.
So, I have an authentication app registered in my Azure tenant (where Intune resides) and appropriate permissions added (get_data_warehouse and get_device_compliance), admin consent granted. I have Azure Data Factory running where I am trying configure linked service of OData type. I filed in all the fields (AutoResolveIntegrationRuntime, Service URL, AAD service principal with Key, Tenant, Service principal ID and key) except 'AAD resource' (resource url). I have no idea what it is referring to. Tried everything (app's home url, redirect uri, app id uri), but connectivity test fails. Most of the times getting such error:
'Failed to create OData connection to RequestUrl Failed to get access token by using service principal. Error: invalid_resource, Error Message: AADSTS500011: The resource principal named <whatever I try> was not found in the tenant...'
Is there any documentation about ADF to Intune connection. If now, what is 'AAD resource' (url) in here???
Many thanks for any hints.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(192, 26%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHM%3C/text%3E%3C/svg%3E)
Hello @TaciakDawid,
Thanks for the ask and also for using the forum . There is no specific connector for intune .
Regarding the question on "AAD resource" , can you please share a screenshot of what you are seeing ?
Thank
Himanshu
Hello ,
Just wanted to follow up as we have not heard from you . Can you please help us share more info as aaked above . Just in case if you have a resolution , we request you to please do share that with the community here .
Thanks & stay safe
Himanshu
Hello Himanshu,
many thanks for your reply. Yes, this is still not being resolved. Screenshots:
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(169.60000000000002, 62%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMA%3C/text%3E%3C/svg%3E)
Hi @Taciak, Dawid ,
I am trying to do the same thing. I was able to get rid of this error message by using Application ID Uri as the AAD Resource. Then, the error message is changed to
Application 'GUID'(APP_NAME) is not assigned to a role for the application 'AAD_RESOURCE_URL'(APP_NAME)
Do you know anything about this error? or any update on your attempt?
I was able to successfully create a connection using this value for AAD Resource: https://api.manage.microsoft.com/
I came across this value in the sample Git repo: https://github.com/microsoft/Intune-Data-Warehouse/tree/master/Samples/CSharp
I was able to successfully create a connection using this value for AAD Resource: https://api.manage.microsoft.com/
I came across this value in the sample Git repo: https://github.com/microsoft/Intune-Data-Warehouse/tree/master/Samples/CSharp