Switch a Solution from Excel to SQL Server Using Parameters

The idea of using power query parameters to rapidly change which data sources your tables are coming from, has been around for a long time. What we are going to do in this video is to take that concept and extend it; so that we can use parameters, not just to change the data source, but to change the data type, from Excel to SQL Server.