Microsoft Certified: Power BI Data Analyst AssociateDeploy and maintain assetsEasy
A data analyst has developed a Power BI report that sources data from an on-premises SQL Server database. The report is published to a Power BI workspace. To ensure that users can view the latest data in the report, which component must be installed and configured in the on-premises network?
- APower BI Desktop
- BPower BI Report Server
- COn-premises data gateway
- DPower BI mobile app
Show answer & explanationAnswer & explanation
Correct answer: C. On-premises data gateway
For Power BI services in the cloud to connect to on-premises data sources like SQL Server, an on-premises data gateway is required. This gateway acts as a bridge, securely transferring data between the cloud and the local network.
Why the other options are wrong
- A. Power BI Desktop is for report development, not for enabling cloud-to-on-premises data refresh.
- B. Power BI Report Server is for hosting Power BI reports on-premises, not for connecting cloud services to on-premises data sources.
- D. The Power BI mobile app is for viewing reports on mobile devices, not for enabling data connectivity.
On-premises Data Gateway
A software component installed on a local network that acts as a bridge, enabling secure data transfer between Power BI cloud services and on-premises data sources.
- Required for cloud services to access on-premises data.
- Encrypts and compresses data during transfer.
- Supports various on-premises data sources.
Memory trick: Cloud needs a Gateway to reach local Data.