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) ...

Learn the differences between scalar and table-valued functions in T-SQL and how to use them for better query performance and readability.