PL-300 · Question #375
You publish a dataset to the Power BI service. The dataset contains a connection to an on- premises Microsoft SQL Server database. You attempt to configure a scheduled refresh but cannot select the…
The correct answer is B. The server name in the PBIX file does not match the data source name in the gateway. In Power BI, when you configure a data source to use an on-premises data gateway, the server name and other connection details in your PBIX file must match the data source configuration in the gateway. If there's a mismatch in the server name or other connection details, the…
Question
You publish a dataset to the Power BI service. The dataset contains a connection to an on- premises Microsoft SQL Server database. You attempt to configure a scheduled refresh but cannot select the appropriate on-premises data gateway. You confirm the following with the administrator of the gateway:
- You have the appropriate permissions to use the gateway.
- The data source was created on the gateway.
- The gateway has a status of Running.
What is the most likely reason the gateway is unavailable?
Options
- AThe type of data source is not supported by the on-premises data gateway.
- BThe server name in the PBIX file does not match the data source name in the gateway.
- CThe credentials for the data source are invalid.
- DThe data source is configured to use single sign-on (SSO).
How the community answered
(19 responses)- B84% (16)
- C11% (2)
- D5% (1)
Explanation
In Power BI, when you configure a data source to use an on-premises data gateway, the server name and other connection details in your PBIX file must match the data source configuration in the gateway. If there's a mismatch in the server name or other connection details, the scheduled refresh won't work, and you won't be able to select the appropriate gateway.
Community Discussion
No community discussion yet for this question.