Versions Compared

Old Version 1

changes.mady.by.user Andrews, Steven

Saved on

compared with

New Version 2

changes.mady.by.user Andrews, Steven

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Note

This solution should only be used on SQL Servers within our CWF network.


Panel

If using Power BI

Image Added

Image Added

Image Added

  1. Search windows for "Environment Variables"

    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 name 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.


Panel
bgColor#fff

If using SSMS

  1. On the Connection Screen, click on Options
  2. Go to the Connection Properties Tab
  3. Check both Encrypt connection and Trust server certificate
  4. Connect to the database

...

Page properties
hiddentrue


Related issues