Skip to content
datastudyguides

PL-300 · 1.1.2 · Prepare the data

Data source settings

Change data source settings, including credentials and privacy levels

Data source settings controls stored credentials and without changing query steps.

Change credentials and privacy

Power Query Data source settings with Edit Permissions open and privacy levels None, Public, Organizational and Private visible.

Data source settings changes how an existing connection authenticates and how isolates it. Edit Permissions changes credentials or privacy. Clear Permissions removes stored credentials.

Privacy controls data movement

matter most when Power Query combines sources and tries to fold work back to them.

Credentials and privacy solve different problems

Credentials answer who are you? Privacy levels answer how may this source be combined with other sources? Changing a password belongs to credentials. Preventing Power Query from moving private data into another source belongs to privacy.

Treat those as separate troubleshooting paths on the exam.

Exam clue: credentials and privacy belong in Data source settings, not in the Applied Steps list.

Key points

  • Edit Permissions: change credentials or
  • Clear Permissions: remove stored credentials
  • Private: most restrictive privacy level
  • Privacy levels: control safe source combinations

Click an underlined term for a one-line explanation, or see them all in the glossary .

Exam trap

Private sources cannot fold data into another source, even another Private source.

Sources · 2 Microsoft Learn pages Show ▾

Checked on October 4, 2026. Report a problem

Go deeper on Microsoft Learn

Checked against Microsoft Learn on October 4, 2026. Report a problem with this card

How well do you know this?