Dynamics Community Forum Thread Details

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:

https://docs.microsoft.com/en-us/powerapps/maker/data-platform/virtual-entity-walkthrough-using-odata-provider

Background:-

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 60.242.85.213:1967
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 --