Reply
Member
Posts: 48
Registered: ‎11-15-2016
Accepted Solution

Single Gateway Issue

Hi Community,

 

I'm having an issue with updating my datasets in Power BI web. Data in my new reports pulled from Azure database but I also have reports build on data coming from normal SQL server and I have set up Gateway for that SQL server and currently updating those reports using that gateway.

  •  So the question is how do I update my datasources with data from Azure database as if we can only have one gateway?
  • Is there a way to have multiple gateways set up to be able to update other datasets??

 

 

Thanks in advance.

 

 

Regards

Abduvali


Accepted Solutions
Highlighted
Moderator
Posts: 4,015
Registered: ‎03-10-2016

Re: Single Gateway Issue

Hi @Abduvali,

Do you install Power BI on-premises gateway or Power BI personal gateway? If you install on-premises gateway, add Azure SQL Server data source under the registered gateway, you will be able to schedule refresh for you dataset that contains on-premises SQL Server data source and Azure SQL data source. If you install personal gateway, just enter credential for Azure SQL Server, and you should be able to schedule refresh for your dataset.

Besides, you don’t have to install multiple gateways to update datasets. Just add data sources of other datasets under your currently registered gateway, you will be able to refresh other datasets.


Thanks,
Lydia Zhang

View solution in original post


All Replies
Highlighted
Moderator
Posts: 4,015
Registered: ‎03-10-2016

Re: Single Gateway Issue

Hi @Abduvali,

Do you install Power BI on-premises gateway or Power BI personal gateway? If you install on-premises gateway, add Azure SQL Server data source under the registered gateway, you will be able to schedule refresh for you dataset that contains on-premises SQL Server data source and Azure SQL data source. If you install personal gateway, just enter credential for Azure SQL Server, and you should be able to schedule refresh for your dataset.

Besides, you don’t have to install multiple gateways to update datasets. Just add data sources of other datasets under your currently registered gateway, you will be able to refresh other datasets.


Thanks,
Lydia Zhang

Member
Posts: 48
Registered: ‎11-15-2016

Re: Single Gateway Issue

@v-yuezhe-msft

 

Hi Lydia,

 

Thanks for the advice.

 

 

Regards

Abduvali