On-premises data sources In this blog post we will have a look, how to integrate Power Automate with an on-premise SQL server. For this purpose I locally installed Microsoft SQL Server and installed the Adventure Works sample database. Additionally I added a new SQL server login, with read/write permissions for the Adventure Works database. (In integration scenarios, you most probably restrict this service user to some views or stagging tables, required for your integration). Azure on-premises data gateway To be able to integrate with your on-premise database, you need to install the azure on-premises data gateway on your SQL server. When you start the setup, you can choose between two types of setup. We will choose the type of setup that supports Power BI, Power Apps and Power Automate: Then you follow the installation procedure and at a certain point you will be asked for the e-mail address of the user that shall be used for the integration. Here you shou...
Private blog about Microsoft Power Platform