Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowData Days is here! Join us now for 60+ days of learning, challenges, and connection. Learn more
I am trying to connect Power BI to multiple on premise SQL Server instances. What is the advantage of using a gateway?
Solved! Go to Solution.
Hi @Stharwani,
The Power BI gateway acts as a bridge, providing quick and secure data transfer between on-premises data and Power BI.
In your scenario, after you connect to SQL Server databases from Power BI Desktop, create reports and publish the Power BI Desktop file to Power BI Service, you can use gateway to refresh your dataset in Power BI Service, this way, each time you make changes in SQL Server data source, the changes will be reflected in dataset and reports in Power BI Service based on refresh schedule, for more details, please review the following link.
https://powerbi.microsoft.com/en-us/documentation/powerbi-gateway-enterprise-manage-sql/
Thanks,
Lydia Zhang
Hi @Stharwani,
The Power BI gateway acts as a bridge, providing quick and secure data transfer between on-premises data and Power BI.
In your scenario, after you connect to SQL Server databases from Power BI Desktop, create reports and publish the Power BI Desktop file to Power BI Service, you can use gateway to refresh your dataset in Power BI Service, this way, each time you make changes in SQL Server data source, the changes will be reflected in dataset and reports in Power BI Service based on refresh schedule, for more details, please review the following link.
https://powerbi.microsoft.com/en-us/documentation/powerbi-gateway-enterprise-manage-sql/
Thanks,
Lydia Zhang
Hi Lydia, the link redirects me to the current page. Can you please update it. Thanks. @Anonymous
Hi @Stharwani,
Please refresh your page, the link opens a new webpage. You can also check the following link:
https://powerbi.microsoft.com/en-us/documentation/powerbi-gateway-enterprise-manage-sql/
Thanks,
Lydia Zhang
Don't miss out on Data Days, June 15 through August 7. Learn Fabric, Power BI, SQL, AI and more.
Check out the May 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 5 | |
| 4 | |
| 3 | |
| 2 | |
| 1 |
| User | Count |
|---|---|
| 11 | |
| 11 | |
| 5 | |
| 4 | |
| 3 |