Page History

If using Power BI

1. Search windows for "Environment Variables" from the windows search bar in the start menu

   Image RemovedImage Added

   Tip
   There are two options that come up. One of them is for adding variables for the system and the other is to add variables to your account. Select the option to Edit environment variables for your account.

   
   

2. Click New... to add a new environment variable for your user.
   
   
   
3. Add a variable with the name "PBI_SQL_TRUSTED_SERVERS"
   
   
   1. The variable value is a comma separated list of server names. If you needed to connect to SQLProdDb and SQLProdDb2, you can enter "SQLProdDb1,SQLProdDB2"
   2. The asterisk (*) can be used as a wildcard for a server. In this example, "SQL*Db" would match SQLTestDb, SQLProdDb, SQLServerDb, etc.
4. Click OK

After applying this setting, restart Power BI Desktop. You may also need to recreate your datasource connection through Home → Transform data → Data source settings.