Azure / Azure/Azure-DataFactory
Azure data factory: Odata connector building incorrect URL to intune
- Dominant language
- PowerShell
- Stars
- 529
- Forks
- 623
- PR merge metrics
- No merged PRs in 30d
Description
Cannot connect to Intune data warehouse via odata connector in Azure Data factory.
1. Linked service to Intune connection test shows success.
2. Creating a dataset using this linked service. I can select the entity in I want to get data for, in this case "dates", but preview fails.
Viewing the error, its clear that Azure Data Factory is constructing the odata url to the entity incorrectly. It is placing the entity "devices" in the api-version parameter, when it should be part of the path.

-- Linked service, can connect successfully.

--creating data source,
1. linked service connection still works as expected.
2. I can select the entity from the dropdown but preview fails.
ERROR - copied from ADF:
_Requesting response from path dates and query $top=10 failed with status code BadRequest and message {"Message":"{\r\n \"_version\": 3,\r\n \"Message\": \"An error has occurred - Operation ID (for customer support): 00000000-0000-0000-0000-000000000000 - Activity ID: 55ab088d-6119-43bd-860a-0ef811ca0491 - Url: https://fef.msub03.manage.microsoft.com/ReportingService/DataWarehouseFEService/?%24top=10&api-version=dates\",\r\n \"CustomApiErrorPhrase\": \"\",\r\n \"RetryAfter\": null,\r\n \"ErrorSourceService\": \"\",\r\n \"HttpHeaders\": \"{}\"\r\n}"}.
Activity ID: 3e602cff-62a9-414c-970e-123090e343ca_
Notice in the URL constructed by ADF, the "dates" entity is placed in the api-version parameter.
This is default behavior, but obviously incorrect.
How can i resolve this?
Contributor guide
Assessment
This issue has not been assessed yet.