Microsoft Certified: Power BI Data Analyst AssociateDeploy and maintain assetsEasy
A data analyst needs to configure a data refresh for a Power BI dataset that connects to an on-premises SQL Server database. The refresh must occur daily outside of business hours. The SQL Server database is located within the company's private network. What Power BI component is essential for enabling this scheduled refresh?
- APower BI Premium Capacity
- BPower BI Gateway
- CPower BI Embedded
- DPower BI Dataflow
Show answer & explanationAnswer & explanation
Correct answer: B. Power BI Gateway
The Power BI Gateway is required to establish a secure connection between the Power BI service (cloud) and on-premises data sources like SQL Server databases. Without the gateway, the Power BI service cannot access the data for scheduled refreshes.
Why the other options are wrong
- A. Power BI Premium Capacity provides dedicated resources and features but does not replace the need for a gateway for on-premises connectivity.
- C. Power BI Embedded allows embedding Power BI content into applications, unrelated to on-premises data refresh connectivity.
- D. A Power BI Dataflow is for data preparation and transformation in the cloud, not for enabling connectivity to on-premises sources.
Power BI On-premises Data Gateway
The Power BI On-premises Data Gateway acts as a secure bridge between Power BI cloud services and on-premises data sources, enabling scheduled data refreshes and Live Connections.
- Connects cloud to on-premises data
- Required for scheduled refresh of on-premises sources
- Required for Live Connection to on-premises sources
- Installed on a local machine
Memory trick: The Gateway is the secure bridge to your home data.