question

MohsenAlam-2960 avatar image
0 Votes"
MohsenAlam-2960 asked PRADEEPCHEEKATLA-MSFT commented

What is the Path value in Azure Data Factory' Odata Connector while connecting to Intune Data Warehouse?

After long journey of trial and errors, I was able create and test an OData linked service using these values:

Service URL: https://fef.{LOCATION}.manage.microsoft.com/ReportingService/DataWarehouseFEService/{ENTITY-COLLECTION}?api-version=v1.0
for example, https://fef.msua08.manage.microsoft.com/ReportingService/DataWarehouseFEService/dates?api-version=v1.0

Authentication Type: Service Principal with Key

AAD Resource: https://api.manage.microsoft.com/

Tenant: Tenant GUID

Service Principal ID: App ID

Service Principal Key: App Secret


However, I couldn't create a dataset using this linked service. The OData Dataset connector requires a "Path" value. I couldn't figure out what value it needs? I tried putting different values such as: /dates, /ReportingService/DataWarehouseFEService/dates?api-version=v1.0, /, dates

None of them works. All of them are throwing this error:

Requesting response from path /ReportingService/DataWarehouseFEService/dates?api-version=v1.0 and query $top=10 failed with status code BadRequest and message {"ErrorCode":"UnsupportedApiVersion","Message":"{\r\n \"_version\": 3,\r\n \"Message\": \"An error has occurred - Operation ID (for customer support): 00000000-0000-0000-0000-000000000000 - Activity ID: a8469b91-c664-4d66-ba16-5ed5e8fed043 - Url: https://fef.amsua0702.manage.microsoft.com/ReportingService/DataWarehouseFEService/dates?api-version=v1.0?$top=10",rn \"CustomApiErrorPhrase\": \"\",\r\n \"RetryAfter\": null,\r\n \"ErrorSourceService\": \"\",\r\n \"HttpHeaders\": \"{}\"\r\n}","Target":null,"Details":null,"InnerError":null,"InstanceAnnotations":[]}.

So, what values to put in the Path field to get it to work?

Thanks in advance!




azure-data-factorymem-intune-generalmem-intune-admin-center
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

MohsenAlam-2960 avatar image
1 Vote"
MohsenAlam-2960 answered PRADEEPCHEEKATLA-MSFT commented

I get it to work!


The acceptable value for Path field looks like this: /ReportingService/DataWarehouseFEService/{entity-collection}?api-version=v1.0, for example, /ReportingService/DataWarehouseFEService/devices?api-version=v1.0.

The caveat is that we can't use the Preview Data feature when we define datasets with this type of path value. We can use dataset in the pipeline without any issue. The Preview Data feature doesn't work because it adds ?$top=10 query to the endpoint URL, which essentially puts two '?' in the same URL.



· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hello @MohsenAlam-2960,

Glad to know that your issue has been resolved. And thanks for sharing the solution, which might be beneficial to other community members reading this thread.

0 Votes 0 ·