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

Mohsen Alam 11 Reputation points
2022-05-05T17:44:43.143+00:00

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\\",\\r\\n \"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 Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,075 questions
Microsoft Intune
Microsoft Intune
A Microsoft cloud-based management solution that offers mobile device management, mobile application management, and PC management capabilities.
4,692 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Mohsen Alam 11 Reputation points
    2022-05-05T23:07:12.237+00:00

    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 person found this answer helpful.