How to Add Multiple SQL Servers to `PBI_SQL_TRUSTED_SERVERS` and `SqlTrustedServers` in Power BI?

[manoj_0911]

Hi,

I’m trying to configure Power BI Desktop and Power BI Service (Gateway) to trust multiple SQL servers. I’ve set the following environment variable for Power BI Desktop:

``` PBI_SQL_TRUSTED_SERVERS = aws rds sql server 1,****; aws rds sql server 2,****```

However, if i place only one server it works, and the semicolon to separate the server entries doesn’t seem to be recognized.

Similarly, in Power BI Service (Gateway), I tried updating the `SqlTrustedServers` value in the `GatewayCore.dll.config` file:

```aws rds sql server 1;aws rds sql server 2 ```

But again, only when i kept only one server.

Is there a correct way to configure multiple SQL servers in these settings, or is it limited to only one server at a time? its very critical for us , because we are in middle of an new customer deployment, Any guidance would be appreciated!

Thanks in advance!

[manoj_0911 · Accepted solution]

This is worked for me "Use a comma to separate server entries and No spaces between the entries in both the `PBI_SQL_TRUSTED_SERVERS` and `SqlTrustedServers` settings."