Courseiva
Prepare the data →easyMultiple Choice

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 →

How Courseiva writes practice questions · Editorial policy

You might also like

Similar PL-300 questions

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.