Hii, I want to import data in PowerBI using ODATA, but i get the following error: The metadata document could not be read from the message content. UnexpectedXmlElement : The element 'edmx:Edmx' was unexpected for the root element. The root element should be Edmx. : (0, 0) See screenshots for all settings and entities:
I stumbled upon the same error. For me, it was fixed when I selected OData version 3 instead of OData 4. I also used “as a link” as association option but I don’t think that matters. Hope this will help you!
I've the same problem. The ODATA-service works with the tools Tableau and Postman. PowerBI generates an error.