From April 2017 onward we are able to use On-premises Information Gateway for Azure Evaluation Providers. This implies you possibly can join your Tabular Fashions hosted in Azure Evaluation Providers to your on-premises information sources via On-premises Information Gateway. On this publish you learn 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 could have an Azure subscription
- You have already got an up and working occasion of Azure Evaluation Providers (AAS)
- You already put in and configured the newest 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” (Verify Conditions part beneath for extra particulars)
- This publish covers the most typical state of affairs which doesn’t contain Kerberos, Proxy Server, OKTA and many others…
Studying: In case you are not that acquainted with 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 acknowledged within the “Necessities” part, you will need to verify in case your situations of Azure Evaluation Providers, Energy BI Service and On-premises Information Gateway situated in the identical “Area”.
The explanations behind which can be:
- 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’t see the gateway, due to this fact, you’re unable to schedule automated information refresh in Energy BI Service
- To get the most effective efficiency and extra reliability, you need 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 circumstances folks created their Energy BI account a very long time in the past and maybe they didn’t set the proper area for his or her Energy BI Service to sit down 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 favor to create the Azure Evaluation Providers in one other area. In that case, it’s endorsed to put in a brand new occasion of On-premises Information Gateway in a separate server and alter the “Gateway Area” in the course of the set up.
To verify the “Area” of your situations observe 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”
