If you want to use on-premises data in Azure or Power BI you need to install a so called gateway. A quick search resulted in four possible gateway downloads! Which one do you need? It's so confusing!
 |
| Microsoft Gateways for Azure and Power BI |
Solution
There are two different gateways but with several names, versions and purposes:
- Data Management Gateway
This gateway is used for Azure Data Factory and Azure Machine Learning, but it was also used for Power BI. However, Power BI now uses the On-premises data gateway! I think / hope that this gateway will be deprecated and replaced by the On-premises data gateway in the near future.
Download (32 and 64bit): https://www.microsoft.com/en-us/download/details.aspx?id=39717 - On-premises data gateway
This gateway comes in three flavors, but you can only install one per server. - On-premises data gateway
This installer is for Power Apps, Logic Apps, Microsoft Flow and Power BI (Enterprise only).
Download (64bit): https://www.microsoft.com/en-us/download/details.aspx?id=53127 - On-premises data gateway Power BI
This installer is also for Power Apps, Logic Apps, Microsoft Flow and Power BI, but has an extra option for a Personal Power BI gateway. If you do not need that, you could just use the installer above, which will have the same result.
Download (64bit): https://powerbi.microsoft.com/en-us/gateway/ - On-premises data gateway Azure Analysis Services
This is a (temporary) installer for Azure Analysis Services (AAS) only and it can used be for one AAS server only. It will soon merge with the standard installer.
Download (64bit): https://docs.microsoft.com/en-us/azure/analysis-services/analysis-services-gateway
Use source for multiple online services
Since you can only install one gateway per server, the On-premises data gateway has some challenges if you want to use your on-premises source for multiple online services like Power BI and AAS or for two AAS servers. In that case you install the first gateway on the source server itself and a second gateway on a separate on-premises server that can reach the first source server. A bit expensive to a have a server running for a data gateway only, but for now this is the only solution.
 |
| One source and two online services: two servers with their own gateway |
Note: details per gateway will be posted in separate posts (AAS)
Keep it up!
ReplyDeleteis there any improments on Azure to connect on-Premises server without using gateways
ReplyDeleteYes, for example ADF and SSIS can now use Azure Virtual Network and a VPN connection to connect to on-premises servers. But which Azure part do you want to use and what kind of source do you want to ingest?
Delete