Forum Discussion

rstov3r's avatar
rstov3r
Regular Visitor
10 years ago

Odata Error: The Feed's metadata document appears to be invalid

I am having this issue using both Power BI and Power Query in Excel. I am not getting this error with a similar connection using a regular connection in excel 
rstov3r's avatar
rstov3r
Regular Visitor
10 years ago

Nothing happens when I add /$metadata to the end of that URL nothing happens. When I remove that tag and put in my basic auth, I get the following:

 

 

 

 

  • rstov3r's avatar
    rstov3r
    Regular Visitor
    10 years ago

    Same as the above response

    • pqian's avatar
      pqian
      Icon for Microsoft Employee rankMicrosoft Employee
      10 years ago

      rstov3r, the response should be a JSON format string.

       

      Looks like your target end point uses a custom OData implementation, and they did not follow the contract fully. Can you contact them and ask them about their $metadata implementation?