Forum Discussion
multiple Personal Gateways
can you load your spreadsheet to one-drive? If so It will update automatically every hour without setting up refresh. This way you'll only have to install the gateway on the server. Also if you can create a vpn into your company’s private network on your laptop that will work as well.
One drive is a good solution. Thanks for your suggestion.
but being able to sync for multiple data sources which may not always have a single gateway available to cover is a valid situation to me.
As a workaround could you use a different power BI account login for the secondary gateway, but In general you should only need one gateway. if you have data loaded into a excel workbook it cannot be refreshed without loading it to one-drive. the excel workbook can only be refreshed if it is connected to a supported online or on-prem data source. if you have data sources that cross over multiple domains/servers/networks I would suggest creating a vpn on one server/pc that allows these servers to talk to each other.
we use corporate account here. so there is no second account that I can use.