Had a question about using parameters to control a query used with Get and Transform (Power Query) in Excel 2016 or Power BI. This article gives a nice example:

Here is another technique that uses single values rather than a table:

With the move to Cloud computing, many organisations are thinking about their next move after an on premise Data Warehouse. Azure provides 2 possibilities: Azure Data Lake or Azure SQL Data Warehouse.

This article gives a very good summary of the situation and reasons for adopting a particular strategy: https://www.mssqltips.com/sqlservertip/4970/data-lake-vs-data-warehouse/