Download as PPTX, PDF, TXT or read online from Scribd
Download as pptx, pdf, or txt
You are on page 1/ 19
POWER BI
D ATA G AT E WAY The data gateway acts as a bridge that enables Power BI to access, refresh, and interact with data from on-premises data sources such as databases, file servers, and other systems. The data gateway helps maintain the security and privacy of your data by allowing you to control the flow of data between your on-premises environment and the cloud-based Power BI service. On-premises data On-premises data gateway gateway (standard mode) (personal mode)
Power BI, Power Apps,
Azure Logic Apps, Cloud services it works with Power Automate, Azure Power BI Analysis Services, Dataflows
Serves multiple users with access control per
Included data source
Runs as an app for users who aren’t administrators Included
Runs as a single user with your credentials Included
Import data and set up scheduled refresh Included Included
Direct Query support Included
Support for a live connection to Analysis Services Included
Key features and functions of the Power BI data gateway include:
Data Refresh: The data gateway enables scheduled data refresh for Power BI reports and datasets that connect to on-premises data sources. This ensures that your reports always display the most up-to-date information. Data Source Connectivity: It supports various data sources, including SQL Server, Oracle, SharePoint, and more. It can also work with different connection types, such as DirectQuery, Live Connection, and Import. Data Privacy and Security: The gateway helps maintain the security of your data by allowing you to configure data source credentials and control access to on-premises data. On-Premises Data Movement: The gateway doesn't move data to the cloud. Instead, it acts as a pass-through mechanism, transmitting data securely between your on-premises data sources and the cloud-based Power BI service. High Availability: You can set up high-availability configurations for the gateway to ensure uninterrupted access to your on-premises data sources. Need to click on these Ellipsis
A F T E R T H E D ATA G AT E WAY I S CONFIGURED, RETURN TO THE D ATA S E T S E T T I N G S PAG E I N A P P. P O W E R B I . C O M W O R K S PAC E Create a new gateway Window username Select the Gateway Need to click on the workspace Refresh Dataset
