Issue OData.Feed Power query: The feed's metadata document appears to be invalid

[FrancescaBatt]

Dear members,

I have an issue when I try to use OData.Feed source instead of Web source in Power BI using token authentication.

When I use the web source the response is correct and the power query code is the following:

let
URL = "xxx"
Source = Web.Contents(URL, [Headers=[Authorization="Bearer MyToken"]])
in
Source

where URL is the endpoint and "MyToken" is the current token. 

Instead when I try with OData.Feed, the sintax is the following:

let
URL = "xxx"
Source = Web.Contents(URL, [Headers=[Authorization="Bearer MyToken"]])
in
Source

and returns this error to me:

OData: The feed's metadata document appears to be invalid. Error: A supported MIME type could not be found that matches the content type of the response. None of the supported type(s) 'application/xml' matches the content type 'text/html'.
Details:
DataSourceKind=OData
DataSourcePath=xxxxxxxxx

Does anyone have any ideas on how to fix?

Thank you!

[FrancescaBatt]

HI @Anonymous ,

Thank you for your answer.

I try to add the Implementation option in this way:

But unfortunately I have still the error.

Thank you!

[Anonymous]

Hi @FrancescaBatt ,

I found a similar thread, see if diggity's answer helps you.

OData: The feed's metadata document appears to be invalid

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data