cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sperry1625
Continued Contributor
Continued Contributor

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.

 
1 ACCEPTED SOLUTION

Accepted Solutions
sperry1625
Continued Contributor
Continued Contributor

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.

View solution in original post

5 REPLIES 5
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
Continued Contributor
Continued Contributor

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.

 

 

 

sperry1625
Continued Contributor
Continued Contributor

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.

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

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.

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.

Users online (2,259)