cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sperry1625
Resolver III
Resolver III

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

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

3 REPLIES 3
DeviKrishna
Resolver II
Resolver II

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
Resolver III
Resolver III

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.

 

 

 

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

Helpful resources

Announcements
User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Users online (1,447)