[!INCLUDE SQL Server Azure SQL Database Azure SQL Managed Instance] COLUMNS_UPDATED tests for UPDATE or INSERT actions performed on multiple columns. To test for UPDATE or INSERT attempts on one ...
In the last two posts in this series I showed how removing columns from the tables used in a Power Query merge operation can improve refresh performance. In this post I’ll show you a different trick ...
Last week I was working on a Power BI custom data connector for a customer and I came across a problem that has been bothering me for a while. The “Invoke Custom Function” button is a very powerful ...
Leveraging Microsoft SQL Server, we have made it easier for app makers to enable their users to take pictures and upload files in their apps. App makers can now use the Microsoft SQL Server connector ...