cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sperry1625
Solution Supplier
Solution Supplier

How to Add/Create Azure SQL Virtual Tables in Dataverse?

I am trying to create Virtual Tables in Dataverse that point to my Azure SQL Server.  I have found some documentation on creating the necessary Virtual Connection, but I cannot get it to work.  When I go and create a new Virtual Entity Data Source these are my only options:

 

sperry1625_5-1637673062550.png

I selected OData v4 Data Provider but am not sure how, or where, to get the information it is asking for:

sperry1625_6-1637673277957.png

O tried putting in the URL for my Azure SQL instance, xxx.database.windows.net, but it did not like that.  What am I missing?  How do I point it to a specific database?  I have been unable to find any good documentation on how to do this.

 

Thank you.

 
Regards,

-S

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

1 ACCEPTED SOLUTION

Accepted Solutions

I was able to install the Virtual Connector Data Provider (Preview) into my Environments. I was able to create a Virtual Entity Data Source using the connector to my Azure SQL Instance. I was then able to create a Virtual Table that referenced my Azure SQL data. Woo hoo.

 

Still working on the details but this is promising.

 

Thanks.

Regards,

-S

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

View solution in original post

9 REPLIES 9
DeviKrishna
Super User
Super User

Hi sperry1625,

 

Please use the URL as -https://XXAZURESQLXX.database.windows.net/odata/

The below URL was helpful. Did you refer the same?

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

 

Please mark my answer as verified if you find this useful.

My Blog: Dynamics 365 Key Topics – https://d365topicsbydk.com/
My Youtube Channel : https://www.youtube.com/channel/UCxSIryP2ah2VpEFr-Z72t1A

 

Regards

Devi

sperry1625
Solution Supplier
Solution Supplier

I have located what I was looking for. I do not want to setup or use an OData connector.  I want to use the SQL Server (Preview) Virtual Connector.  This link gave me the information I needed to get this process started.

 

I will follow up on this thread with my progress.

 

Thank you.

 

 

 

Regards,

-S

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

I was able to install the Virtual Connector Data Provider (Preview) into my Environments. I was able to create a Virtual Entity Data Source using the connector to my Azure SQL Instance. I was then able to create a Virtual Table that referenced my Azure SQL data. Woo hoo.

 

Still working on the details but this is promising.

 

Thanks.

Regards,

-S

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Sunidhigambhir1
Helper II
Helper II

Hello,

1.Sign in to Power Apps, and then select Settings > Advanced settings.

2.Go to Settings > Administration > Virtual Entity Data Sources.

3.On the actions toolbar, select New.

4.On the Select Data Provider dialog box, select from the following data sources, and then select OK.

NHelgren
Power Apps
Power Apps

can see you already found the Virtual Connector Provider. I have recently added videos walking you through the process as well. We have released the same capabilities for SharePoint and Excel. https://docs.microsoft.com/en-us/power-apps/developer/data-platform/virtual-entities/create-virtual-... 

Hi,

Even though I have created a PowerApp with a connection to SQL, I'm not having any success in creating a virtual table from external data. It doesn't see the existing SQL connection. (I know it exists and it's working)

I select add connection besides SQL server but get errors when entering credentials. I selected windows or server authentication, and nothing seemed to work.

Am I missing any previous steps to create the virtual table from SQL (on-prem)?
Thank you!

Hi @omelo , 

 

It may be the authentication you are using on your connector. Currently only SQL authentication and AAD authentication are supported for the new tool. We are working to review the remaining authentication types. 

You can find this documented here: Create virtual tables using virtual connectors (preview) (Microsoft Dataverse) - Power Apps | Micros...

omelo
Helper II
Helper II

Hi @NHelgren , thank you for responding!

 

It didn't work with the SQL authentication either. 

I'll keep testing!

The Virtual Table process uses the same connector infrastructure as creating a standard connection, we just reuse the Connection interface in the wizard so it should be identical and showing any existing SharePoint or SQL connection you have created. I would suggest opening a case with the connector team if the created connections are not appearing in the list.

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Users online (6,105)