Most ERP systems are deployed on-premise with an actual local database. These are accessible by tools, such as the Power BI Designer, but what if we want to access the On-Premise database from the cloud-based Power BI site for Office 365? This means that before we are able to access any data from an Office 365 site, we need to install and configure secured access to our local machine or server from the Office 365 site in the cloud. We do just this in the Power BI Personal Gateway.
Tip
For additional information on the Power BI Personal Gateway, refer to https://support.powerbi.com/knowledgebase/articles/649846.
In Chapter 7, Deploy and Present Reports to the Power BI Site, you will learn how to upload and view your Power BI report file to the Office 365 site. With the Power BI Personal Gateway configured, it will give us the way to access the On-Premise database from the cloud.
Here is how you configure the gateway:
From the Office 365 for the Power BI site...