Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

July 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! Learn more

Reply
Abduvali
Skilled Sharer
Skilled Sharer

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

1 ACCEPTED SOLUTION
Anonymous
Not applicable

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

2 REPLIES 2
Anonymous
Not applicable

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

@Anonymous

 

Hi Lydia,

 

Thanks for the advice.

 

 

Regards

Abduvali

Helpful resources

Announcements
FabCon and SQLCon Barcelona 2026

FabCon & SQLCon – Barcelona 2026

Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.

60 days of Data Days Carousel

Data Days 2026

Join Fabric Data Days 2026: 60 days of free live/on-demand sessions, challenges, study groups, and certification opportunities.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.