How to refresh 3 pbi files with a vpn each

[pedroccamaraDBI]

Hello all,

I have 3 power bi files that i am working with, each one with its own vpn to access the data and also each one with a gateway.
Everytime i have to refresh it, i have to disconnect a vpn and connect another.
Everyone has any advice on how could i refresh all the data without any input from me, for example to disconnect and connect a vpn?
Thanks all of you

Best regards

Pedro

[pedroccamaraDBI]

Hello @GilbertQ 
I don't know what kind of gateway i have installed. My gateway is the On-premises data gateway.
 Do i have to create a dataflow? I started yesterday reading some things about it. Can you help?
Thank you for your answer
Best regards

Pedro

[GilbertQ]

Hi @pedroccamaraDBI 

The only thing I could think of is to have 3 gateway servers each connected to each VPN.

Then have the data loading into a dataflow, which you can then connect to the dataflows using Power BI Desktop and not have to disconnect from each VPN.