It’s common that data is laid out across columns in Excel for reporting purposes. E.g. Revenue for each product is laid out across the columns in excel for each month. However this may not work well as a data source. Power Query provides Unpivot option to solve this issue. Sample workbook can be downloaded here.
Month: May 2015
While migrating a power query solution across environments (Dev to UAT to Prod) changing connection variables for each power query is a tedious task. Here is a way to make the connection variable dynamic. The sample here has two power queries connecting to SQL server source. Create an excel table and call it Parameter with