Microsoft Power BI Cookbook

SQL Server database

1. Create two parameters of text data types, BI Server and BI Database, from the Query Editor in Power BI Desktop:
   • Click on New Parameter from the Manage Parameters dropdown on the Home tab

2. If known, enter the list of alternative values for these parameters:

SQL Database Name Parameter with two Suggested Values

3. Create a new query that accepts the server and database parameters as inputs to the Sql.Database() function for connecting to SQL Server:

let Source = Sql.Database(#"BI Server", #"BI Database") in Source

4. Name this query AdWorksParam and reference this source query in other queries in the model, such as Employee ...