You know this everybody – you need to install a whole new SQL Server on the customers Windows Server. And the customer doesn’t have the time or money to wait for you to click around the GUI and sit around and watch the progress-bar move every second. So why not do this in a fully automatic way and in the same time save both effort and expensive time doing so?
The Power Query tool has just been updated and there are some pretty neat features rolled out: New Transfomation: Use Headers as First Row. Column Name field in Merge Columns dialog. Quick Access Toolbar in Query Editor dialog. Warning for stale data previews in new queries. Function Invocation from Search. Preserve Excel Number formats in the worksheet on query refresh.