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.
Hi billzhang1123,
Was wondering if you ever found what was causing the failure on your server?
Haven't tried myself, but is the personal gateway currently working from multiple locations with the same corporate account?
