Hi, I have a very simple scenario with a SQL Database located in a On-premises server. I followed the Create virtual tables using virtual connectors (preview) (Microsoft Dataverse) - Power Apps | Micros... and managed to connect to the server and everything seems to work by the end of the tutorial, but when I try to do any CRUD operation I got an error message as follows:
The specified domain does not exist or cannot be contacted
Error Code: 2147746340
Session Id: guid
Activity Id: guid
Timestamp: date
APIM request was not successful : BadRequest : The specified item 'id' is not found. inner exception: The specified item 'id ' is not found.
When I create or update the item the operation is done but still the error message shows up. If I try to use the table in any Model-driven app only create and list operations work, however after creation the detail view fails to load. I cannot get details, actually the details appears for a few seconds and the error message shows up with the close action.
I tried the tutorial several times, and use two different servers, two different databases and several different tables with no luck. Does anyone have an idea of what I did wrong, because I see many people who has followed the tutorial and have the virtual tables working.
