Forum Discussion

FrancescaBatt's avatar
FrancescaBatt
Frequent Visitor
3 years ago

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

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!

2 Replies