Query Logs Me Out of the Other Query.

[ShrimpCreole]

I'm hoping my issue is simple.  I am able to connect to each of the below sources, which pull finanical data from seperate locations to be consolidated.   The credentials are basic with a User name and Password.  Each has a seperate user name.  When I connect to one, it logs me out of the other, so I have to re-enter the credentials.   I do, then it logs me out of the other, and so on.   How do I resolve this problem?

let
Source = Json.Document(Web.Contents("https://int.LightspeedADP.com/lsapi/AcctBalance/76220042")),

let
Source = Json.Document(Web.Contents("https://int.LightspeedADP.com/lsapi/AcctBalance/76204356")),

[lbendlin · Accepted solution]

you can't. This is a design limitation.

On the Power BI service you can work around that by using a gateway and creating separate connections.  On the Power BI Desktop you have no solution (maybe there's a trick in the global data source settings where you can remove the higher level URL, but that is only a temporary reprieve).

You can raise an issue at https://issues.powerbi.com . If you have a Pro license you can consider raising a Pro ticket at https://powerbi.microsoft.com/en-us/support/pro/