Introduction
In Power BI, gateways are crucial components that ensure secure data transfer between on-premises data sources (databases, files, etc.) and cloud-based services. They enable seamless integration, real-time reporting, and scheduled refreshes for interactive dashboards while maintaining robust security.
Types of Gateways
-
On-Premises Data Gateway:
- It is ideal for connecting on-premises data sources to Power BI and other Microsoft cloud services.
- Supports secure, real-time, or scheduled data transfer.
-
Personal Gateway:
- Designed for individual users in non-enterprise environments.
- Limited features and only supports personal report updates.
Functions of Gateways
- Data Refresh: Schedule or on-demand updates for reports.
- Live Connection: Real-time data access for dashboards.
- Security: Encrypted communication between on-premises sources and the cloud.
Summary of Gateway Usage
Type of Report |
Gateway to Use |
Server Details |
Cloud-only reports |
vnet-cdw-mgi-prod-snet-cdw-mgi-pbi-integration |
mgi-cdw.kemin.com |
On-premises-only reports |
Kemin-Data-Gateway-Cluster Kemin-DGCluster-KC KeminPBI-Gateway |
ssas.kemin.com uskibisql3 bpw.kemin.com m3data.kemin.com m3livedata.kemin.com Additional Sources: Local files (e.g., Excel) and files from OneDrive can also be used. Note: For SharePoint, no gateway is required; credentials can be validated directly under the data source. |
Hybrid (Cloud + On-Premises) |
KeminPBI-CGW-01 |
uskibisql3 bpw.kemin.com m3data.kemin.com m3livedata.kemin.com mgi-cdw.kemin.com Additional Sources: Local files (e.g., Excel) and files from OneDrive can also be used. Note: For SharePoint, no gateway is required; credentials can be validated directly under the data source. |
Key Notes
- Local Files: Local Excel files and OneDrive-hosted files can be integrated into On-Premises-Only and Hybrid reports.
- SharePoint: SharePoint does not require a gateway; validate credentials under the data source in Power BI.
Benefits of Using Gateways
- Seamless Integration: Bridges on-premises systems with cloud services.
- Data Security: Maintains secure, encrypted data transfers.
- Scheduled Refresh: Automates data updates for consistent reporting.
Access the Full Documentation
For detailed guidelines, including the complete list of server configurations and use cases, download the PDF document here Power BI data gateways and connections overview.pdf.