Use VBA to Automate Power Query scenarios in Excel 2016

Use VBA to Automate Power Query scenarios in Excel 2016

In case you missed this important functionality in Excel 2016, today’s short blog post is written to raise some attention to a wonderful feature. You can write VBA code or PowerShell scripts to automate the creation of queries, change their M...