User Profile
baoyan
Microsoft Employee
Joined 6 years ago
User Widgets
Contributions
Re: OData feed unconnectable: The odata.context url is invalid
Hi dax , Thanks for your reply. I have tested a lot for this, and I'm sure it's not the permission problem since I disabled permission check for my service locally. And as I known, the Odata 7.4.1 generated odata.context URL is always valid for Power Query, its context.url template is always http://servicedomain/$metadata#entity , while the template of Odata 7.5.4 is more complex, it can be http://servicedomain/$metadata#entity(property()). So I actually want to know is that whether the Power Query not support the metadata url format of OData 7.5.4, are you plan to support this url format.6.1KViews0likes4CommentsOData feed unconnectable: The odata.context url is invalid
We got the error message: "The odata.context url 'https://ourservice.com/$metadata#TestNode(toTestNode())' is invalid" when we tried to connect to our server with odata expand operation. The odata feed url is like "https://ourservice.com/TestNode?$expand=toTestNode", and our server use Odata Core/Edm 7.5.4, the metadata url 'https://ourservice.com/$metadata#TestNode(toTestNode())' is auto generated by OData, why the Power Query marked it as invalid url and disconnected?6.1KViews0likes12Comments
Data Privacy
Microsoft Fabric Community and Privacy
To learn more about how we manage your data, please review the Microsoft Fabric Community Data Privacy guide.