I have multiple reports created in my desktop and uploaded to a group workspace on the service. Some of the reports get data from spreadhsheet on my laptop. Some of them get data from Oracle in the company's private network.
I installed Person Gateway on a Windows server in our priviate network. It synced pretty well for the data on our private network.
However I installed another Personal Gateway on my laptop to sync spreadsheet data on my laptop. I thought this is the only way to sync the data on my laptop. Is this correct?
After I configured the Personal Gateway on my laptop, the one on the server stopped working. It kept saying 'Register gateway failed'. Is this because I can only have one Personal Gateway configured or something? I need both because now my Oracle data on the private network stopped sync.
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.
you can uninstall the one on your laptop to test this theory, but i am pretty certain that you should be able to have multiple instances of the Gateway running within your organization.
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.
I uninstalled the one on my laptop. The one on the server still failed to register. I am going to re-install the one on the server too. hope it will take over control again after reinstall.
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?
I am not sure it will be relevant to your use case scenario but MS released an entreprise version of the gateway. I haven't looked much into it yet, but it seems designed to address the needs of more complicated situations than the personal gateway (you may be able to have the entreprise on your LAN and personal on your laptop?)
Enterprise gateway has major limitations (no calculated columns or tables, no data transformation, no DAX queries in the Power BI Desktop etc.
The question stills stands. How can we use multiple personal gateways?