Expose data from on-premises system to cloud services

Using on-premises data gateway you can provide quick data transfer between cloud services and your on-premises data sources such as files, SQL database, file system etc.

It acts as a bridge between cloud services and on-premises systems, and it’s secure as it provides encryption.

As of now it supports Power BI, Logic Apps, PowerApps, Microsoft Flow and Azure Analysis Services.

And there are some specific data sources that supports above cloud services.

Download on-premises data gateway.

On-premise system should be always ON and should always be connected to internet. For better performance prefer wired connection over Wi-Fi.

Please refer to https://docs.microsoft.com/en-us/power-bi/service-gateway-onprem for more information and installation instructions.

For demonstration I’ll be using Power BI to get data from AxDB database from a locally deployed (VHD) Hyper-V instance.

Login to Power BI online service using the same credentials that you have used while configuring the data gateway.

Navigate to manage gateways page.

You’ll find your data gate way is already listed, and you can see it’s status.

Now next step is to add our AxDB database as a data source under our gateway cluster.

Give a desired name, select data source type as SQL server. And select authentication method as Windows authentication and provide credentials.

For our case User: MININT-F36S5EH\Administrator

Password: pass@word1

After adding the successfully, you can see the status from top.

Now we can use this data source for our reports.

Note: There is a catch in using this SQL data source for Power BI, you should develop the Power BI report on the same machine or within the same network where your on-premise data gateway is installed. Publish the report, then gateway comes in picture to refresh the data on demand or on recurrence basis.

For other cloud services like Logic Apps and PowerApps you can access the data from anywhere you want and above limitation is not valid.