Question

ODATA PowerBI

0

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:

asked 2022-05-18

Batikan Dulger

2 answers

Chris Dekker · Answer 1 · 2022-05-27

Hi Batikan,

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!

Kind regards,

Chris

Anthony Bakker · Answer 2 · 2022-06-02

I've the same problem. The ODATA-service works with the tools Tableau and Postman. PowerBI generates an error.

Greetz,

Anthony