Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
Solved! Go to Solution.
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.
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
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?
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.