Connecting to oData Microsoft Usage Analytics from Data Factory is throwing an error

Leidy Alexandra Jimenez Moncada 11 Reputation points
2022-07-05T17:53:13.03+00:00

Hi all,

I'm facing this issue when trying to connect to the oData source for Microsoft Usage Analytics report, we are trying to get the information to a database on Azure SQL but I'm getting the following error:

Supported content type could not be found from response of serviceurl or serviceurl+"/$metadata", please check the response from your other client such as browser. A supported MIME type could not be found that matches the content type of the response. None of the supported type(s) 'application/json;odata.metadata=minimal;odata.streaming=true;IEEE754Compatible=false,

I have also tried with SSIS but I'm getting a compatibility issue as well. Someone have faced the same issue and found a solution?

Thanks in advanced for your help!

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,208 questions
{count} votes

1 answer

Sort by: Most helpful
  1. KranthiPakala-MSFT 46,602 Reputation points Microsoft Employee
    2022-07-06T18:42:45.867+00:00

    Hello @Leidy Alexandra Jimenez Moncada ,

    Thanks for the question and using MS Q&A platform.
    As per my understanding, you are receiving the above error message while trying to access Odata Microsoft Usage Analytics using ADF. Please correct if my understanding is wrong.

    From the error message, it seems like the response content type isn't supported. Supported response content type is 'application/json

    As mentioned in the error, could you please check the response from other clients like your browser or POSTMAN. Also, I would suggest giving a try with serviceurl+"/$metadata" and see the behavior.

    Do let us know how this test goes.

    Thank you

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.