Skip to content
SumOfficeSumOfficeSumOffice

Power Query: trust and privacy

Source privacy levels, trust decisions, and connection settings. Operations on this page: 6.

Source privacy levels, trust decisions, and connection settings. Terms are in the glossary.

Request

Field TypeScript type Req.
operation “pq-data-source-settings-apply” yes
subsetId string yes
action “change-source-path” | “clear-permissions” | “set-privacy-level” yes
scopeId string yes
newPath string no
level string no

Response on success · pq-data-source-settings-apply

Field TypeScript type Req.
operation “pq-data-source-settings-apply” yes
outcome PqDataSourceSettingsOutcome yes

Minimal JSON template

{
"operation": "pq-data-source-settings-apply",
"subsetId": "<subsetId>",
"action": "change-source-path",
"scopeId": "<scopeId>"
}

Request

Field TypeScript type Req.
operation “pq-data-source-settings-list” yes
subsetId string yes

Response on success · pq-data-source-settings-list

Field TypeScript type Req.
operation “pq-data-source-settings-list” yes
sources PqDataSourceEntry[] yes

Minimal JSON template

{
"operation": "pq-data-source-settings-list",
"subsetId": "<subsetId>"
}

Lists the privacy levels assigned to sources.

Request

Field TypeScript type Req.
operation "pq-privacy-level-list" yes
userStore PqPrivacyLevelAssignment[] no
workbookDeclared PqPrivacyLevelAssignment[] no
knownScopes PqSourceScopeWire[] no
subsetId string no

Response on success · pq-privacy-level-list

Field TypeScript type Req.
operation "pq-privacy-level-list" yes
entries PqPrivacyLevelListEntry[] yes

Minimal JSON template

{
"operation": "pq-privacy-level-list",
"requestedBackend": "native-desktop"
}

Clears the privacy level assigned to a source.

Request

Field TypeScript type Req.
operation "pq-privacy-level-reset" yes
canonicalScope string yes

Response on success · pq-privacy-level-reset

Field TypeScript type Req.
operation "pq-privacy-level-reset" yes
outcome PqPrivacyLevelWriteOutcome yes

Minimal JSON template

{
"operation": "pq-privacy-level-reset",
"canonicalScope": "<string>",
"requestedBackend": "native-desktop"
}

Assigns a privacy level to a source.

Request

Field TypeScript type Req.
operation "pq-privacy-level-set" yes
canonicalScope string yes
level string yes

Response on success · pq-privacy-level-set

Field TypeScript type Req.
operation "pq-privacy-level-set" yes
outcome PqPrivacyLevelWriteOutcome yes

Minimal JSON template

{
"operation": "pq-privacy-level-set",
"canonicalScope": "<string>",
"level": "<string>",
"requestedBackend": "native-desktop"
}

A trust decision for a source: allow, deny, or remember for the session.

Request

Field TypeScript type Req.
operation "source_trust_decision" yes
action ContractSourceTrustAction yes
observation ContractSourceTrustObservation yes
grant ContractSourceTrustGrantBinding | null no
session ContractSourceTrustSessionBinding | null no
requestedBackend ComputeBackendKind | null no

Response on success · source_trust_decision

Field TypeScript type Req.
operation "source_trust_decision" yes
decision ContractSourceTrustDecision yes

Minimal JSON template

{
"operation": "source_trust_decision",
"action": "<ContractSourceTrustAction>",
"observation": "<ContractSourceTrustObservation>",
"requestedBackend": "native-desktop"
}

Documentation assistant

Answers are assembled from the documentation and may be inaccurate — check the sources.