Microsoft Certified: Power BI Data Analyst AssociateDeploy and maintain assetsEasy
A Power BI report relies on a dataset that connects to an on-premises SQL Server database. The report is published to the Power BI Service. To enable scheduled refresh for this dataset, what must be configured in the Power BI Service?
- AAn Azure Data Lake Storage Gen2 connection
- BAn On-premises Data Gateway
- CAn Azure Analysis Services instance
- DA Power BI Dataflow
Show answer & explanationAnswer & explanation
Correct answer: B. An On-premises Data Gateway
An On-premises Data Gateway acts as a secure bridge between Power BI Service and on-premises data sources. It is essential for enabling scheduled refresh of datasets that connect to data residing within a private network.
Why the other options are wrong
- A. Azure Data Lake Storage Gen2 is a cloud storage solution, not relevant for connecting to on-premises SQL Server.
- C. Azure Analysis Services is a cloud analytical engine, not directly used for connecting to on-premises SQL Server for scheduled refresh.
- D. A Power BI Dataflow is for data preparation and transformation, not for connecting to on-premises data sources for dataset refresh.
On-premises Data Gateway
A secure software agent that connects Power BI Service to on-premises data sources, enabling data refresh and DirectQuery functionality.
- Acts as a bridge to on-premises data.
- Required for scheduled refresh.
- Installed on a machine within the network.
Memory trick: The gateway unlocks the on-premises data highway.