Forum Discussion
Refresh multiple data sources from different VPN in a single dataset
Hello, We have one single report that has data imported from two different servers each one from different VPNs. We tried to create a gateway cluster and added gateways from the two VMs of each ...
In the past, to achieve this, we created one server for each VPN. Added an intermediate layer database to get the data from all sources. Finally, one gateway from this intermediate layer database to PBI cloud. Also this approach helps daily backups what is being pushed to PBI cloud.
We had luck with multiple gateways but has issues in combination of VPNs. so I came with this solution.
Note: what we did not try fully is to setup all VPN in the same server and try in different times to refresh.