cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Robindsouza
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:

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

 

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)

 

Robindsouza_0-1627807785326.png

 

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 --

 

Any Assistance or Advice would be most appreciated.

 

Regards,

 

Robin DSouza

 

 

0 REPLIES 0

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

secondImage

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 (2,702)