Close this search box.

Link Notes to a SQL Server Table in Excel Using Power Query

Connect Excel to SQL Server

While working at Microsoft I had access to the SQL data from many of the applications used by the Azure Capacity Planning and Supply Chain teams. One of my functions was to track the changes and movement made to capacity (server racks) across time. To accomplish this, I used Power Query in Excel to link […]