This video will walk you through how to connect to data that is stored in SQL using a Virtual Table. This will allow you to use SQL tables in the Power Platform as if it were stored in a Dataverse table. This walk through uses the Virtual Connector Provider which reduces the time needed to create virtual tables.
For more information check out:
Create virtual tables using virtual connectors (Microsoft Dataverse)
https://docs.microsoft.com/en-us/powe...