Forum Discussion
Query Logs Me Out of the Other Query.
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")),
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/
1 Reply
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/