updateDatasourcesConnections

Updates the data sources connections 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

Connections Details

FDPBI_CONNECTIONS_DETAILS

No

Provide the json input. (See example in Inputs)

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

Connections Details File Path

FDPBI_CONNECTIONS_FILE_PATH

No

The File Path specifying the connections details.

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

Inputs

Input Name

Input Code

Required

Description

 

Input Name

Input Code

Required

Description

 

Azure Power BI Account

FDPBI_INP_ACCOUNT_CODE

No

The Power BI Cloud Account

 

Connections Details

FDPBI_INP_CONNECTIONS_DETAILS

No

Provide the json input.

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

{ "connectionsDetails": [ { "objectNames": [ "input1", "input2" ], "filterCriteria": "searchString", "newserver": "${{MySemanticModelServer}}", "newdatabase": "${{MySemanticModelDatabase}}" }, { "objectNames": [ "input1", "input2" ], "filterCriteria": "searchString", "newurl": "${{MySemanticModelConnUrl}}" } ] }

Connections Details File Path

FDPBI_INP_CONNECTIONS_FILE_PATH

No

The File Path specifying the connections details.

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

Provide either this or FDPBI_INP_CONNECTIONS_DETAILS

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