Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Virtual Table using Odata V4

Hi There,


I have a question around building virtual tables using a Odata V4 provider.


I have used the instructions as started in the link below but don't get a response from the EndPoint using the provider.


Documentation link:



I would like to expose my SQL server Database using an Odata Web service and build a virtual table that is to be consumed by a Power Apps Portal.


I am currently able to do that and test successfully using postman but when I try to set up the virtual table, The OData V4 provider is not able to establish a connection.


I have ensured I am using the correct Entity Set and Collection Set Names and also ensured I am reference a GUID as a Primary Key. Below is a screenshot of a success response using Postman. (Status 200 ok)




Error in the Plugin Trace Logs:

Exception Error:

Exception type: System.Net.Sockets.SocketException
Message: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond
at System.Net.Sockets.Socket.DoConnect(EndPoint endPointSnapshot, SocketAddress socketAddress)
at System.Net.ServicePoint.ConnectSocketInternal(Boolean connectFailure, Socket s4, Socket s6, Socket& socket, IPAddress& address, ConnectSocketState state, IAsyncResult asyncResult, Exception& exception)
-- End stack trace --

Exception type: System.Net.WebException
Message: Unable to connect to the remote server
at System.Net.HttpWebRequest.GetResponse()
at Microsoft.Xrm.DataProvider.Odata.V4.Plugins.Client.EdmModelLoader.GetModel(ODataDataSource info, IDictionary`2 httpHeaders)
at Microsoft.Xrm.DataProvider.Odata.V4.Plugins.Client.InstrumentedEdmModelLoader.GetModel(ODataDataSource info, IDictionary`2 httpHeaders)
at Microsoft.Xrm.DataProvider.Odata.V4.Plugins.Client.ExceptionTranslationEdmModelLoader.GetModel(ODataDataSource info, IDictionary`2 httpHeaders)
-- End stack trace --


Any Assistance or Advice would be most appreciated.




Robin DSouza




Helpful resources

PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.


Power Apps Community Call

Please join us on Wednesday, October 20th, at 8a PDT. Come and learn from our amazing speakers!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Kudoed Authors
Users online (1,622)