Forum Discussion
Scheduled refresh breaking with VPN secured on-premise SQL Database table
Hi biswedishdevil,
- When I want to setup the scheduled refresh to use the new gateway I can't select the new one. (although if I go to Manage gateways I've setup the datasource and it's online).
Assume the dataset only have one SQL Server data source, and you have created the SQL server data source use the same connection information and credential as in desktop under two data gateways, those two gateways should be available for this dataset.
- What happens when the dataset i've created have two source tables that come from two different servers? As I far as I know, I can only use 1 gateway for each dataset scheduled refresh.
Assume the dataset have two SQL Server data sources, we must create two SQL Server data sources use the same connection information and credential under the same data gateway. If those two data sources are created under different data gateways, the dataset can't be configured to use data gateway.
Best Regards,
Qiuyun Yu
I've tried applying the solution, but I find two extra problems:
- When I want to setup the scheduled refresh to use the new gateway I can't select the new one. (although if I go to Manage gateways I've setup the datasource and it's online).
- What happens when the dataset i've created have two source tables that come from two different servers? As I far as I know, I can only use 1 gateway for each dataset scheduled refresh.
Hi biswedishdevil,
- When I want to setup the scheduled refresh to use the new gateway I can't select the new one. (although if I go to Manage gateways I've setup the datasource and it's online).
Assume the dataset only have one SQL Server data source, and you have created the SQL server data source use the same connection information and credential as in desktop under two data gateways, those two gateways should be available for this dataset.
- What happens when the dataset i've created have two source tables that come from two different servers? As I far as I know, I can only use 1 gateway for each dataset scheduled refresh.
Assume the dataset have two SQL Server data sources, we must create two SQL Server data sources use the same connection information and credential under the same data gateway. If those two data sources are created under different data gateways, the dataset can't be configured to use data gateway.
Best Regards,
Qiuyun Yu
Good morning,
Although the first point is solved, the second is not...
Let's imagine the following scenario:
Server 1 contains SQL Server Database A
Server 2 contains SQL Server Database B
I have a Power BI Dataset that imports data from both SQL Server Database A and SQL Server Database B, that live in different Servers.
Now I want to schedule data refresh, therefore I need to setup a Gateway. As far as I understood, in order to avoid VPN autentitaction, I need to install an on-premise gateway in the server where the database is located.
In this case, I assume I need to install a gateway in Server 1 and another gateway in Server 2, so I can reach both servers without the need of the VPN authentication. But as you said, the dataset deployed in the Power BI service cannot use more than one gateway... so, what is the solution then?