hardMultiple ChoiceObjective-mapped

PL-900 Practice Question: Refer to the exhibit

Exhibit

Refer to the exhibit.

```
{
  "name": "SalesReport",
  "dataset": "SalesDB",
  "refreshSchedule": {
    "frequency": "Daily",
    "time": "02:00",
    "timeZone": "UTC",
    "days": ["Monday","Tuesday","Wednesday","Thursday","Friday"]
  },
  "dataSources": [
    {
      "type": "Sql",
      "connectionString": "Server=sqlsrv;Database=SalesDB;Integrated Security=SSPI;"
    }
  ]
}
```

Refer to the exhibit. The JSON represents a Power BI dataset refresh configuration. After deployment, the refresh fails with an error indicating that the data source credentials are missing. Which step must be taken to resolve the issue?

⚠ Common exam trap

Candidates often assume the JSON configuration can include all deployment details, but Power BI intentionally separates credentials from deployment artifacts to enforce security, so the error points to a missing manual configuration step in the service.

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

✓

Configure the data source credentials in the Power BI service under dataset settings

The error indicates that the data source credentials are missing in the Power BI service, not in the JSON configuration. The JSON only defines the refresh schedule and dataset parameters; credentials must be configured separately in the Power BI service under dataset settings because they are sensitive and not stored in deployment artifacts. Option B is correct because you must manually enter or update the credentials in the Power BI service to authenticate against the data source.

Answer analysis

Option-by-option breakdown

For each option: why learners choose it and why it is or isn't the right answer here.

✗
Add the credentials to the JSON configuration and redeploy
Why it's wrong here
Credentials are not stored in the JSON; they are configured in the service.
✓
Configure the data source credentials in the Power BI service under dataset settings
Why this is correct
Credentials must be set in the service for scheduled refresh.
✗
Set the data source privacy level to Organizational
Why it's wrong here
Privacy levels affect query folding, not missing credentials.
✗
Change the connection string to use SQL Server authentication
Why it's wrong here
The connection string is valid; the issue is missing credentials, not the authentication type.

Visual reference

Go deeper

PL-900 Practice Question: Refer to the exhibit

Exhibit

Why each option matters

Option-by-option breakdown

Related to this question