From April 2017 onward we will use On-premises Information Gateway for Azure Evaluation Providers. This implies you may join your Tabular Fashions hosted in Azure Evaluation Providers to your on-premises information sources by means of On-premises Information Gateway. On this publish you discover ways to setup and configure the On-premises Information Gateway in addition to how one can configure Azure Evaluation Providers to hook up with the on-premises database(s) by way of the gateway.
- You’ve got an Azure subscription
- You have already got an up and working occasion of Azure Evaluation Providers (AAS)
- You already put in and configured the most recent model of On-premises Information Gateway
- Your occasion of Azure Evaluation Providers, your occasion of Energy BI Service and your On-premises Information Gateway are all in the identical “Area” (Examine Stipulations part beneath for extra particulars)
- This publish covers the most typical state of affairs which doesn’t contain Kerberos, Proxy Server, OKTA and so forth…
Studying: If you’re not that conversant in On-premises Information Gateway then I encourage you to learn this and for extra in-depth learn this article. You may additionally watch this video from Adam Saxton discussing On-premises Information Gateway.
As said within the “Necessities” part, it is very important verify in case your cases of Azure Evaluation Providers, Energy BI Service and On-premises Information Gateway positioned in the identical “Area”.
The explanations behind which are:
- Your On-premises Information Gateway MUST be put in in the identical Area as your Energy BI Service sits in. In any other case your Energy BI can not see the gateway, subsequently, you’re unable to schedule computerized information refresh in Energy BI Service
- To get one of the best efficiency and extra reliability, it’s important to create On-premises Information Gateway Useful resource in Azure aspect in the identical area as your Azure Evaluation Providers lives in
However, in some instances individuals created their Energy BI account a very long time in the past and maybe they didn’t set the best area for his or her Energy BI Service to take a seat in. Now, they should create an occasion of Azure Evaluation Providers, however, because of their organisation privateness and safety, they don’t need to (or maybe not allowed to) create the occasion of Azure Evaluation Providers within the area that their Energy BI tenant sits in. So that they would like to create the Azure Evaluation Providers in one other area. In that case, it is strongly recommended to put in a brand new occasion of On-premises Information Gateway in a separate server and alter the “Gateway Area” throughout the set up.
To verify the “Area” of your cases comply with the steps beneath:
Energy BI Service Area:
- Login to your Energy BI Service
- Click on the query mark on high proper aspect of the web page
- Click on “About Energy BI”
