E81   Power query and Microsoft Flow using On premises Data Gateway
Channel: BizTalk360
Date: 2018-12-21

In this recording, Kent shortly goes through the installation of the On-premises Data gateway. Next, he shows how to create a Power Query in a Microsoft Flow, which queries an on-premise SQL Server database. Kent shows an interesting demo in which is he retrieves data from a local SQL Server database and uses that data to dynamically create an email, via the Outlook connector.