Azure sql Tables not loading into Dataverse with Virtual Connector Provider Connector

[AnthonyDo]

Hi there,

As i did not find where to submit a ticker for this problem i am trying to post it here.

We are trying to connect our Azure database to Dataverse (It is a simple database with dummy data). This with the preview connector “Virtual connector provider”. However, we are only able to load 2 of the 4 tables into Dataverse. We think it might be something with relations? I added some pictures to make it more understandable.

Our Database “virtualdatabase”

The 2 tables we are not able to load:

Orders:

OrderDetails:

Our database diagram:

The 2 tables that did load into Dataverse with all the data in it:

When i do a Advanced find on the connection I’m able to find all the tables:

When I try to add the Orderdetails or Order table I don’t get an option for Primary field of the Virtual Entity:

What could be the problem? Is it because Orderdetails and Orders have a more complex relationship to the other tables and that is not supported yet?

Thank you in advance for helping me out.

Kind Regards

[Syndicate_Admin]

This is not a power platform connectors issue. Can someone from Dynamics 365 respond to this?

[Syndicate_Admin]

I requested a SME to answer this question.

[AnthonyDo]

@Syndicate_Admin ,

Thank you so much. I had no clue where to go with this.

Kind regards,

Anthony

[AnthonyDo]

Deer @Syndicate_Admin ,

Any update on this yet?

Best Regards,

Anthony

[Syndicate_Admin]

I reached out to the group again for a response.

If this reply answers your question or solves your issue, please ACCEPT AS SOLUTION ☑️. If you find this reply helpful, please consider giving it a LIKE 👍.

[Syndicate_Admin · Accepted solution]

Hi - it appears that the 2 tables you are trying to create as virtual tables in Dataverse do no have a "string" type column.

To create a table in Dataverse, you need a primary key and a primary field column. The virtual connector provider will ask you to select a primary key field at the time you are creating the table by automatically showing you a list of columns from your source table that are of type "string". If you dont see any values in the drop down, then the virtual table will not be created.

We are working on removing this dependency in the coming quarter. If you have any further questions about virtual table please email them to dvvt@microsoft.com

[AnthonyDo]

Deer @Syndicate_Admin 

Thank you very much for the information and support!

Best Regards,

Anthony