cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AnthonyDo
Helper III
Helper III

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

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”

 

AnthonyDo_0-1629698917143.png

 

 

The 2 tables we are not able to load:

 

Orders:

 

AnthonyDo_1-1629698917150.png

 

OrderDetails:

 

AnthonyDo_2-1629698917154.png

 

 

Our database diagram:

 

AnthonyDo_3-1629698917162.png

 

 

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

 

AnthonyDo_4-1629698917165.png

 

 

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

 

AnthonyDo_5-1629698917181.png

 

 

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

 

 

AnthonyDo_6-1629698917188.png

 

 

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

1 ACCEPTED SOLUTION

Accepted Solutions
Syndicate_Admin
Administrator
Administrator

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

View solution in original post

7 REPLIES 7
Syndicate_Admin
Administrator
Administrator

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

Syndicate_Admin
Administrator
Administrator

I requested a SME to answer this question.

@Syndicate_Admin ,

 

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


Kind regards,

 

Anthony

Deer @Syndicate_Admin ,

 

Any update on this yet?

 

Best Regards,

Anthony

Syndicate_Admin
Administrator
Administrator

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

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

Deer @Syndicate_Admin 

 

Thank you very much for the information and support!

 

Best Regards,

 

Anthony

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.

May UG Leader Call Carousel 768x460.png

June User Group Leader Call

Join us on June 28 for our monthly User Group leader call!

PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

PA.JPG

New Release Planning Portal (Preview)

Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.

Top Solution Authors
Top Kudoed Authors
Users online (1,349)