updateDatasourceCredentials

Updates the data sources credentials for the objects from the specified workspace.

Target Properties

Property Name

Property Code

Required

Description

Property Name

Property Code

Required

Description

Azure Power BI Account

FDPBI_ACCOUNT_CODE

No

The Power BI Cloud Account

Azure Power BI Workspace ID

FDPBI_TGT_WORKSPACE_ID

No

Workspace Id of the Power BI content

Azure Power BI Workspace Name

FDPBI_TGT_WORKSPACE_NAME

No

Workspace Name of the Power BI content. (Workspace Name is case-sensitive)

Project Properties

Property Name

Property Code

Required

Description

Property Name

Property Code

Required

Description

Credentials Details

FDPBI_CREDENTIALS_DETAILS

No

Provide the json input.

  • filterCriteria - Only mandatory when the object e.g: semantic model, has multiple datasources as cloud connections. One can specify search string e.g. “demobi-server”, corresponding to current server or database name, for which to update.

Credentials Details File Path

FDPBI_CREDENTIALS_FILE_PATH

No

The File Path specifying the connections details.

The default is 'credentialsPlan.json' in the FD_ARTIFACTS_DIR.

In Credential Details, Any Personal Access Token type credential goes as type “key”

Inputs

Input Name

Input Code

Required

Description

 

Input Name

Input Code

Required

Description

 

Power BI Account

FDPBI_INP_ACCOUNT_CODE

No

Power BI Cloud account

 

Credentials Details

FDPBI_INP_CREDENTIALS_DETAILS

No

Provide the json input.

  • filterCriteria - Only mandatory when the object e.g: semantic model, has multiple datasources as cloud connections. One can specify search string e.g. “demobi-server”, corresponding to current server or database name, for which to update.

{ "credentialsDetails": [ { "objectNames": [ "input1", "input2" ], "filterCriteria": "searchString", "username": "${{dbusername}}", "password": "${{dbpassword}}" }, { "objectNames": [ "input1", "input2" ], "filterCriteria": "searchString", "key": "${{key/PAT}}" }, { "objectNames": [ "input1", "input2" ], "filterCriteria": "searchString", "sas": "${{sastoken}}" } ] }

Credentials Details File Path

FDPBI_INP_CREDENTIALS_FILE_PATH

No

The File Path specifying the connections details.

The default is 'credentialsPlan.json' in the FD_ARTIFACTS_DIR.

 

Include Objects

FDPBI_INP_INCLUDE_OBJECTS

No

CSV list of specific objects. (Standard Project)

semanticModel1,semanticModel2

For Package based project, when using this operation in workflow, it will pick up object names corresponding to package files having “Update Credentials” ticked.

 

 

Artifacts

This operation doesn’t consume or produce any artifacts.

Endpoint Selection

This operation delegates the selection to the workflow developer to determine.

Endpoint Execution

This operations delegates the execution to the workflow developer to decide.

The following macros are not currently supported in the footer:
  • style