Microsoft Certified: Power BI Data Analyst AssociateDeploy and maintain assetsMedium
A Power BI developer needs to publish a report to a new workspace. The report uses an imported dataset that connects to an on-premises SQL Server database. After publishing, the report displays an error indicating that the data source cannot be found. What is the MOST likely cause of this issue?
- AThe developer did not refresh the dataset after publishing.
- BThe on-premises data gateway is not configured for the new workspace.
- CThe SQL Server firewall is blocking the Power BI service IP addresses.
- DThe workspace does not have a Power BI Premium license.
Show answer & explanationAnswer & explanation
Correct answer: B. The on-premises data gateway is not configured for the new workspace.
For Power BI to connect to on-premises data sources like SQL Server, an on-premises data gateway must be installed and configured. If the gateway is not set up or associated with the new workspace, Power BI will be unable to reach the data source.
Why the other options are wrong
- A. Refreshing the dataset is done after the connection is established; a connection error indicates an underlying setup issue.
- C. While a firewall could block the connection, the gateway acts as the bridge; if the gateway itself isn't configured, the firewall isn't the immediate next step to check.
- D. While Premium licenses offer more features, they are not strictly required for basic connectivity to on-premises data sources via a gateway.
On-premises Data Gateway
The Power BI On-premises Data Gateway acts as a bridge, providing a secure data transfer between on-premises data sources and Power BI service.
- Required for on-premises data access
- Encrypts data in transit
- Needs to be installed and configured
Memory trick: The gateway is the secure bridge from your house to the cloud.