PL-300 Practice Question: You have a Power BI dataset that refreshes daily from an on-premises SQL Server database
You have a Power BI dataset that refreshes daily from an on-premises SQL Server database. The refresh fails with an error 'The data source credentials cannot be used for the connection'. What is the most likely cause?
⚠ Common exam trap
It's easy for candidates to confuse a credentials error with a connectivity error (like the gateway being offline or the server being unreachable), but the specific wording 'credentials cannot be used' points directly to authentication failure, not network or gateway availability.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
The credentials stored in the gateway for the SQL Server have changed or expired.
The error 'The data source credentials cannot be used for the connection' specifically indicates that the credentials stored in the on-premises data gateway for the SQL Server data source have changed or expired. When a Power BI dataset refreshes from an on-premises SQL Server via a gateway, the gateway uses stored credentials to authenticate; if those credentials are no longer valid (e.g., password was rotated), the connection fails with this exact error.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
The on-premises gateway is not running.
Why it's wrong here
A stopped gateway would prevent any data refresh from reaching the on-premises SQL Server and typically raises an error such as 'The gateway is offline' or 'Unable to connect to gateway'. Since the provided error message points specifically to invalid credentials rather than a gateway connectivity failure, this option is incorrect as the root cause.
- ✗
The dataset is using DirectQuery and the connection string is incorrect.
Why it's wrong here
With DirectQuery, the connection string is used to locate the SQL Server and the gateway stores the authentication credentials, but a misconfigured connection string would produce a server-not-found or cannot-connect-to-server error, not an explicit credential error. The error message referenced in the scenario indicates a credential validation failure, so an incorrect connection string does not match the observed diagnostic.
- ✓
The credentials stored in the gateway for the SQL Server have changed or expired.
Why this is correct
The on-premises data gateway stores the SQL Server credentials that the Power BI service uses during refresh. If the SQL Server password was changed or the account expired, the gateway can no longer authenticate to the database, and the refresh fails with a 'The credentials stored in the gateway are invalid' error. Re-validating and updating the credentials in the gateway data source settings resolves this issue, making it the correct root cause.
- ✗
The SQL Server is not accessible from the cloud.
Why it's wrong here
The Power BI service does not reach the SQL Server directly; it sends the refresh request to an on-premises data gateway, which then connects to the SQL Server from inside the corporate network. If the SQL Server were unreachable from the cloud, the failure would occur at the gateway's outbound connection step, producing a network or 'server not found' error rather than a credential-specific error. Therefore, this option is inconsistent with the credential error described.
About these practice questions
This PL-300 question is part of Courseiva's 524-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam dumps. Learn why practice questions differ from exam dumps →
You might also like
Similar PL-300 questions
- You are connecting to an Azure SQL database using DirectQuery. The database has a large table with millions of rows. Use…
- You need to create a date table in Power BI using DAX. Which function should you use to generate a continuous list of da…
- You need to combine data from two tables in Power Query that have the same columns but different row sets. Which operati…
- Which THREE of the following are best practices when preparing data in Power BI for optimal performance?
- Which TWO are valid ways to combine data from multiple sources in Power Query? (Choose two.)
Written by Johnson Ajibi, MSc IT Security
Security Systems Architect · founder of Courseiva
This PL-300 practice question is part of Courseiva's free Microsoft certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the PL-300 exam.