Forum Discussion
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
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
2 Replies
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 ZhangAnonymous
Hi Lydia,
Thanks for the advice.
Regards
Abduvali
