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
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Carousel_PP_768x460_Wave2 (1).png

2022 Release Wave 2 Plan

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

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Top Solution Authors
Top Kudoed Authors
Users online (4,933)