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

Question

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!

Answer 1

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.