web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id : KdtjtluIMD+o6QOYSSJ+aV
Power Platform Community / Forums / Power Apps - Microsoft Dataverse / How to Add/Create Azur...
Power Apps - Microsoft Dataverse
Answered

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

Like (0) ShareShare
ReportReport
Posted on 23 Nov 2021 13:17:59 by sperry1625 760 Super User 2024 Season 1

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.

 
Categories:
Microsoft Dataverse
Tables
I have the same question (0)
  • Devikumari Krishna Profile Picture
    Devikumari Krishna 988 Super User 2024 Season 1 on 24 Nov 2021 at 10:51:36
    Re: How to Add/Create Azure SQL Virtual Tables in Dataverse?

    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-odata-provider

     

    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 Profile Picture
    sperry1625 760 Super User 2024 Season 1 on 29 Nov 2021 at 14:36:56
    Re: How to Add/Create Azure SQL Virtual Tables in Dataverse?

    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.

     

     

     

  • Verified answer
    sperry1625 Profile Picture
    sperry1625 760 Super User 2024 Season 1 on 30 Nov 2021 at 14:13:22
    Re: How to Add/Create Azure SQL Virtual Tables in Dataverse?

    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 Profile Picture
    Sunidhigambhir1 77 on 10 Mar 2022 at 04:47:03
    Re: How to Add/Create Azure SQL Virtual Tables in Dataverse?

    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 Profile Picture
    Nhelgren on 04 May 2022 at 19:29:24
    Re: How to Add/Create Azure SQL Virtual Tables in Dataverse?

    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-tables-using-connectors?tabs=sql 

  • omelo Profile Picture
    omelo 52 on 23 Jan 2023 at 20:42:29
    Re: How to Add/Create Azure SQL Virtual Tables in Dataverse?

    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!

  • Nhelgren Profile Picture
    Nhelgren on 25 Jan 2023 at 15:56:48
    Re: How to Add/Create Azure SQL Virtual Tables in Dataverse?

    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 | Microsoft Learn

  • omelo Profile Picture
    omelo 52 on 27 Jan 2023 at 15:34:50
    Re: How to Add/Create Azure SQL Virtual Tables in Dataverse?

    Hi @NHelgren , thank you for responding!

     

    It didn't work with the SQL authentication either. 

    I'll keep testing!

  • Nhelgren Profile Picture
    Nhelgren on 27 Jan 2023 at 15:44:34
    Re: How to Add/Create Azure SQL Virtual Tables in Dataverse?

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Chiara Carbone – Community Spotlight

We are honored to recognize Chiara Carbone as our Community Spotlight for November…

Congratulations to the October Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 629 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 397 Super User 2025 Season 2

#3
wolenberg_ Profile Picture

wolenberg_ 232 Moderator

Last 30 days Overall leaderboard

Featured topics

Product updates

Microsoft Power Platform Community release plans