What does this mean in PQE online

[JaromBIDEVatDK]

I am trying to add a connection that works fine in the desktop PQE but not online. Online I get the following error message but what does it mean? Where can I find a list of available conncetions? I have tried all the auth types and they all give the same error. Is it something to do with the \\Server\DB string? 

[JaromBIDEVatDK]

@jennratten - How do I use an existing connection for a new query? Do I have to have a different gateway for every sql query to the same server/database? I don't see a way to change the connection name from the dataflow.

[jennratten · Accepted solution]

You do not need to have a separate gateway for each query with the same server/db.  You should have one connection for the server/db and then use that same connection for each query.  Only one gateway can be utilized by dataflow.

You can specify a gateway in a dataflow a couple of different ways.  When you go to get data > SQL (or other data source) > enter your server and database info and then choose a gateway from the list.  Then you will select an authentication type.  If the authentication type, server and database match one that is configured as a connection on the gateway you selected, the user name and password will populate automatically.  The user name will say [ENCRYPTED] and the password will be filled with masked characters (.....).

If you already have a query and you want to assign a gateway, on the ribbon for the Power Query Online editor, go to Options > Project Options and select a gateway.  If you do it that way after you click okay, you will likely get an error message on the queries saying that you have to configure your connection.  Just click the button to do so and follow the prompts.

Connection names cannot be changed from within a dataflow.  You must go to Manage Gateway to do that.

[jennratten]

If you are seeing this message when trying to add a new connection to a gateway, the names of the connections must be unique.  You can see a list of connections and names, add new connections, etc. by going to Manage Gateways in the Power BI Service.  Here are instructions:

https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-data-sources