hardMultiple Choice

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
Embedding credentials in the JSON configuration and redeploying is not how Power BI stores data source secrets; credentials belong in the gateway or cloud connection settings, not the dataset definition. This would be the correct approach only for non-sensitive parameters, not authentication secrets.
✓
Configure the data source credentials in the Power BI service under dataset settings
Why this is correct
Refresh failures citing missing credentials occur because dataset connection details deploy with the report, but authentication secrets are never published. Opening the dataset settings in the Power BI service and supplying the data source credentials satisfies that constraint, allowing the scheduled refresh to authenticate against the source.
✗
Set the data source privacy level to Organizational
Why it's wrong here
Privacy levels govern how Power Query combines data across sources, not whether credentials exist. The refresh error names missing data source credentials, which privacy settings cannot supply. Setting privacy levels would be the right step when data combination behaviour triggers formula firewall errors, not authentication failures.
✗
Change the connection string to use SQL Server authentication
Why it's wrong here
Switching to SQL Server authentication changes the authentication method, but the error states credentials are absent from the dataset configuration entirely. Supplying credentials is the required fix. SQL authentication would be the correct choice where the source rejects Windows integrated authentication and a database login is expected.

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