Create Dataverse Virtual Table from SQL in Azure | Power Platform

Now, you can create a Dataverse virtual table by referencing a SQL Table. This is an easy way to bring in schema from your SQL Table in use and make it into a Dataverse Table.

Let’s see how.

Create SQL Connection Reference

First, let’s create an SQL Connection reference in Power Platform –

1. Go to Connections, create a new Connection.
   
2. Now, you can select the authentication type as SQL Server Authentication. You can choose based on how your setup is, but if you want to quickly test this feature, you can follow this process.
   
3. Then, you need to fill in the Server Name and Database Name.
   You can get the Server Name from here in the Azure Portal. You’ll find a Server name in the SQL Server details.
   
4. And Database Name under the Server itself as
   
5. And fill out the information as below.
   
6. Further, if you scroll, you’ll need Server Admin name which will be on the Server itself.
   
7. And fill the same in the fields below in the connection dialog box. Finally, click Create.
   
8. Connection is now created.
   

Create Table

Here’s how you can create a virtual Table in Power Apps Maker (https://make.powerapps.com/) –

1. Once you are in Power Apps Maker, go to Tables and you can drop down from Create Table menu.
   
2. You’ll see option to Create by connecting to external source.
   
3. Now, you have 2 options at this point of writing this blog. One is SQL and other is SharePoint. We’ll select SQL for this example. Both also use the connection you are logged in.
   You can select the connection we created in the steps above.
   
4. In the next step, you’ll see the Tables from SQL. In this example, our table is student.
   
5. When you click Next, you’ll see the columns from SQL
   
6. Once everything looks good, you can then click Next. Finally, you’ll see he summary of the Dataverse virtual table to be created.
   
7. And finally, the Table will read the data from SQL and display here. The data will not be synced back to SQL.
   

In case you also want to know how to convert a SharePoint list to Dataverse table, you can refer this post – Create Dataverse Virtual Table from SharePoint List | Power Platform

Hope this helps!

Thank you!

This post was originally published on this site