The adapter exposes the table-valued functions as methods that can be invoked directly on SQL Server. For more information about how the adapter supports scalar functions, see Execute Table-Valued ...

Create a BizTalk project, and generate schema for the table-valued function you want to invoke in SQL Server. Create messages in the BizTalk project for sending and receiving messages from SQL Server.

My favourite – and it seems many other people’s favourite – new feature in the February 2022 Power BI Desktop release is support for more datasources (including SQL Server, Azure SQL DB and Synapse) ...