Here’s how you can connect to external SQL table to create a Virtual table in Dataverse.
Continue Reading priyeshwagh777’s Article on their blog
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.
Blog Syndicated with priyeshwagh777’s Permission
More About This Author

Array
Dyn365CE11 September 2023Profitability Analysis on a Project Service Quote | Project Operations
Dyn365CE15 August 2023App Access Checker in Power Platform Admin Center
Dyn365CE15 August 2023Modern Share Experience on Views in Power Platform | [Preview]
Dyn365CE6 August 2023Currency and Exchange Rate fields in a Dynamics 365 CRM entity | [Quick Tip]