'Error previewing Odata data set in Azure data factory

Im accessing intune Datawarehouse from Azure Data Factory. The linked service is created and the test connection works. The linked service accesses intune via a Registered App with permissions to read the intune API.

Im now creating a dataset to the devices dataset in intune. The dataset is able to list all available "tables" , but when i try to preview the data for a selected "table", i get the below error:

Requesting response from path devices 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: 26b1c510-a7bc-4562-9d9a-48b062a8c080 - Url: 
https://fef.msub03.manage.microsoft.com/ReportingService/DataWarehouseFEService/?%24top=10&
api-version=devices\",\r\n \"CustomApiErrorPhrase\": \"\",\r\n \"RetryAfter\": 
null,\r\n \"ErrorSourceService\": \"\",\r\n \"HttpHeaders\": \"{}\"\r\n}"}.

If the linked serice test says it can connect successfully, i am unsure why i cannot preview the data in the dataset.

Appreciate any advice or expertise.



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source