To connect to the Microsoft database, enter your Data Studio account and navigate to the “Add data to report” menu item. Select "Microsoft SQL Server connection from the menu.

Google has been refining Data Studio to provide better blending capability and more flexibility in combining data.