Question 20
A gateway is installed but refresh fails because the mapped SQL data source name differs from the published model. What should be checked?
Explanation
Correct Answer
Match the gateway data source connection details and credentials to the semantic model. Gateway mapping depends on consistent connection configuration, not merely installation.
Incorrect Answers
A gateway is not automatically necessary for supported reachable cloud data sources. This solves “with cloud credentials and no private network restriction”; the stated issue is “data source name differs from the published model”.
The gateway securely relays cloud requests to private network data sources. Its application is “Server is inaccessible from Power BI's cloud service”, not the need “data source name differs from the published model”.
Standard mode supports shared data sources and centralized gateway management. That is a different operating condition from “data source name differs from the published model”: “centralized, shared connectivity for multiple scheduled-refresh semantic models”.