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

Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more

Reply
Stharwani
Advocate II
Advocate II

Connecting to On Premise SQL Servers

I am trying to connect Power BI to multiple on premise SQL Server instances. What is the advantage of using a gateway? 

1 ACCEPTED SOLUTION
v-yuezhe-msft
Microsoft Employee
Microsoft Employee

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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
v-yuezhe-msft
Microsoft Employee
Microsoft Employee

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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi Lydia, the link redirects me to the current page. Can you please update it. Thanks. @v-yuezhe-msft

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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
PBIApril_Carousel

Power BI Monthly Update - April 2025

Check out the April 2025 Power BI update to learn about new features.

Notebook Gallery Carousel1

NEW! Community Notebooks Gallery

Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.

April2025 Carousel

Fabric Community Update - April 2025

Find out what's new and trending in the Fabric community.