cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Frequent Visitor

On-premises data gateway azure

My data sits on multiple SQL servers. Is it a good option to have a separate Power BI server on Azure and set up a gateway on that and from there can we pull data from different SQL servers to the Power BI server?

1 ACCEPTED SOLUTION

Hi @hitesh160790 

 

You can certainly install it on a VM in Azure.

All that needs to happen is the Gateway needs to be installed on a Windows Operating System.

 

Here are some articles may help you:

Install an on-premises data gateway

The Power BI Gateway; All You Need to Know

https://community.powerbi.com/t5/Service/Hosting-On-premises-Power-BI-Gateway-on-azure/td-p/95896 

https://community.powerbi.com/t5/Service/On-premises-Data-Gateway/m-p/249716 

 

Another thing is to keep the on-premise data gateway to run as the latest version. 

 

Community Support Team _ Dina Ye
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
Super User II
Super User II

Hey @hitesh160790 ,

 

I'm not sure what you mean by "Power BI server on Azure"?

Are you referring to this https://powerbi.microsoft.com/en-us/report-server/ that is installed on a virtual machine running in Azure?

 

The on-premises gateway is intended to connect the Power BI Service with your on-premises data sources. If the virtual machine that is hosting the Power BI Report Server is integrated in your local network, it will not be necessary to install a on-premises gateway.

 

Regards,

Tom



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

Thank you @TomMartens for your reply. My all data sources are in Virtual machines. I was planning to buy a new server(VM) which will be on Azure and from there I was planning to install a gateway and pull data from my sources. Is that a good idea? 

Hi @hitesh160790 

 

You can certainly install it on a VM in Azure.

All that needs to happen is the Gateway needs to be installed on a Windows Operating System.

 

Here are some articles may help you:

Install an on-premises data gateway

The Power BI Gateway; All You Need to Know

https://community.powerbi.com/t5/Service/Hosting-On-premises-Power-BI-Gateway-on-azure/td-p/95896 

https://community.powerbi.com/t5/Service/On-premises-Data-Gateway/m-p/249716 

 

Another thing is to keep the on-premise data gateway to run as the latest version. 

 

Community Support Team _ Dina Ye
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

Helpful resources

Announcements
secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

Wave Release 2

Check out the updates in Power BI.

Overview of Power BI 2020 release wave 2!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors